Showing a field that's not present???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to take one Main table(contains a bunch of stuff, but I'm
just concerned with the names column), compare it to a secondary table with a
list of employees and then show on the main table the names that didn't
appear on the main table?
-
For example if the main table has:
John
Jim
Paul
-
And the employee list table has:
John
Jim
Paul
Andy
Cody
-
I'm trying to show on the report that Andy and Cody were not present.
Is this even possible?
Thanks!
 
Take a look at the "unmatched" query in the query wizard. When it runs the
way you want, use the query to build a report.

Good luck

Jeff Boyce
<Access MVP>
 
I just found that out, but didn't think about having it build a report.
Would i just pop that report in as a subreport off my main?
-This main report will have a date range criteria, will this work in
conjunction with that even though it is a subreport?
Thanks again!
 
Jeff

I'm not there, so I can't see what you are referring to.

I was suggesting that you use a query as the basis for a report. Is this
report a "subreport"?

Are you saying you need to provide selection criteria (e.g., date range)?
If so, either embed the criteria as parameters in your query, or create a
form in which you collect those parameters, and have the query refer to the
form.

I thought you wanted to identify which rows in your second table were not in
the first. A query (unmatched) will do this.

Good luck

Jeff Boyce
<Access MVP>
 
Yeah, it is a subreport and the unmatched query worked great. Now I'm just
tryin to find out something. I've asked a few other people but, when I run
the report and the date range box narrows my search down to the few records
i'm looking for; will the unmatched query subreport only look at those
records that the date range narrowed down?
Hope that made sense.
Thanks.
 
Jeff

I suspect that will depend on how you have the subreport defined in your
main report. If you have embedded a subreport in a main report, the
subreport control on the main report will have Parent and Child field
properties defining which key to use to find subreport records.

But without some idea of your data structure, and relationships, it's just a
guess how/if your subreport is related, and if it can relate to the
selection criteria you apply to the main report...
 
Back
Top