A query that shows just the difference between two tables

[Schenectady84]

Every week I am sent an updated excel that shows time entered by managers working on specific project (it is a cumulative table). I upload them into tables in Access. I would like to run a query that would show me just the entries that are new for any given week.

That way I would be able to see who is entering their data later then we ask them too. Unfortunately the tool just gives us the date that the manager is logging their hours for not the actual day they are logging their hours.

Can anyone help me with this?

Edit: There is no unique number associated with an entry... but each entry is unique on it's own as a whole.

 

[Banana]

If you click on "New.." button for a Query in Database windows (as opposed to clicking the first three things in list) you will get a dialog asking how to create a query, and one of option should be "Find Unmatched Record" or something. Click it and set it up to get an idea of how you would compare two tables.

 

[Schenectady84]

If you click on "New.." button for a Query in Database windows (as opposed to clicking the first three things in list) you will get a dialog asking how to create a query, and one of option should be "Find Unmatched Record" or something. Click it and set it up to get an idea of how you would compare two tables.

I did try that, but it wanted to know which fields to compare. I.e. something unique to an entry like a invoice #, transaction id, etc. I don't have any unique fields like that. However, each entry as a whole. date, field2, field3, field4 etc do not have any duplicates as a whole entry if that makes sense...

 

[Banana]

Did it let you select more than one field? I think it was supposed but if you could only choose one field, go and complete the wizard, and take a look at the SQL statement and see if you can set the criteria to "field1 and field 2 and field3" or something like that.

If still stumped, post the SQL here.

 

[Schenectady84]

Hey thanks. I am still new with this stuff. The SQL to find unnmatched LOG_DATE is below. It would not allow me to pick multiple fields in the wizard (I am using 2000). I am not that familiar with SQL so not sure how to do an AND although I'm sure it can't be that hard. If you can show me just how to do two fields I can figure how to do all of them. Thanks for the help!


SELECT [Time Sheet Data 5-19-08].LOG_DATE, [Time Sheet Data 5-19-08].MAJOR_CATEGORY, [Time Sheet Data 5-19-08].MAJOR_CAT_DESC, [Time Sheet Data 5-19-08].SUB_CATEGORY, [Time Sheet Data 5-19-08].SUB_CAT_DESC, [Time Sheet Data 5-19-08].BUDGET_GROUP, [Time Sheet Data 5-19-08].BUDGET_GRP_DESC, [Time Sheet Data 5-19-08].ANALYST, [Time Sheet Data 5-19-08].NAME, [Time Sheet Data 5-19-08].ACTUAL_HOURS
FROM [Time Sheet Data 5-19-08] LEFT JOIN [Time Sheet Data 5-12-08] ON [Time Sheet Data 5-19-08].LOG_DATE = [Time Sheet Data 5-12-08].LOG_DATE
WHERE ((([Time Sheet Data 5-12-08].LOG_DATE) Is Null));

 

[Schenectady84]

HI, I actually figured this out. I just added a few more joins in the design view manually. Thanks for the help anyway!

 

[Banana]

Great- glad you figured it out. It's great use of wizard- to give you a starter to work with so you don't have to wander aimlessly.