i don't know what to call this

[blue weasle]

I have a number of employees that submit data daily and is imported through a GIS program and stored in a dbf table. The dbf is imported into my access db and parsed/formated to be more easily read. What I need to do is know how to display employees that worked a certain day but their data has NOT been imported. I already have an attendance form/table for days worked. Obviously with simple queries I can see who has been imported by day, but since there are so many employees, I have to manualy go through and see which ones haven't been imported. The reason this is so crutial, is that I have data dating back 9 months and I'm trying to get this thing caught up.

Any ideas are appreciated?!?!?!?

 

[Pat Hartman]

Try using an "unmatched" query to identify the missing data. Use the wizard to build it.

 

[blue weasle]

I need to match one employee per date worked against one employee per import. The query won't let me match two fields to create the join that gives me the unique day. Here's a copy of the db, it might help.

Thanks

 

[ecniv]

SELECT CollectionTable.ID, CollectionTable.CollectionDate, qrySubEmployees.EmployeeID
FROM CollectionTable LEFT JOIN 
(select EmployeeTable.EmployeeID, EmployeeTable.Employeefname & " " & EmployeeTable.Employeelname as username from EmployeeTable) AS qrySubEmployees 
ON CollectionTable.UNAME = qrySubEmployees.username

This might be a start?

Not sure if this is the sort of thing you want to do.

Also not all usernames were in the list...

 

[blue weasle]

I found this link but can't decipher how to get it to work in my app.

http://www.access-programmers.co.uk/forums/showthread.php?t=68298&highlight=unmatched+query