compare data in query to field in table return difference

carpstar

Registered User.
Local time
Today, 14:21
Joined
Apr 5, 2002
Messages
30
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.
 
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, 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.:D
 

Users who are viewing this thread

Back
Top Bottom