Recent content by Schenectady84

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

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...

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...

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...