Need Help with Unmatched Queries

[Gary Crisp]

I want to thank everyone for all the help that I have received. I'm still
just a little lost, though. Is there anyone that knows how to find unmatched
records from two(2) excel sheets imported to Access 2003 using the "date"
field as a deciding factor?

Thank-you in advance,
Gary

 

[John W. Vinson]

I want to thank everyone for all the help that I have received. I'm still
just a little lost, though. Is there anyone that knows how to find unmatched
records from two(2) excel sheets imported to Access 2003 using the "date"
field as a deciding factor?

Thank-you in advance,
Gary

Create a new Query.
Choose the Unmatched Query wizard.
Select the two imported tables.
Specify the date field.

If you have problems doing so post back with more details - names of the
tables, datatypes (is it really a Date/Time field? If so does it contain just
dates or dates and times? If the latter do you want to match on the exact
second or on the pure date?)

 

[Gary Crisp]

Thanks for the quick reply. I'll try tonight and post my results.
Thanks,
Gary