compare data in query to field in table return difference

[carpstar]

Hello to all...
Please if anyone can help with this.

Have table "Staff" and table "StaffHrs" which is populated by user entry. Have query "StaffHrs report" to generate report from StaffHrs table.
This is what I'm trying to do: When "StaffHrs report" is ran I need for the StaffId#s that are in "Staff" table StaffID# field but do not appear in the "StaffHrs report" be listed at the end of the report.
Hope this is clear. I know very little to no vb code.
Thanks.

 

[carpstar]

Is this post slipping past everyone, has it been addressed in another post.
Could someone respond, perhaps my question is so dumb that its being ignored.
Please anyone.

 

[Pat Hartman]

Your question is very confusing which I'm sure is why no one has tried to answer. Please try again if I haven't helped.

It sounds like you have a report based on a query and that query has selection criteria that excludes certain staff members. You want a way of printing some information regarding the missing members at the end of the report.

To accomplish this you can create an unmatched query using the wizard. Specify the staff table and the staffhrs report query.

I think the real problem however, and I'm just guessing here, is that you have used an inner join to join the staff table with the staffhrs table and the missing records are really those who don't have reported hours for the period. If that is the case, change the join type to left rather than inner. That will include all staff members whether or not they have reported hours.

 

[carpstar]

Pat, Thank you very much.
I didn't even think to look for the query wizard.
I've tackled lots tougher access problems than this on my own before--I don't know where the mental block came from on this one though. I can't spend as much time as i would like learning access. It's difficult without any classroom training to pick this up on your own, but i'll keep plugging away.

Again thanks it worked fine.

Oh yeah... it wasn't the confusing question as much as the simple
solution.