Need Help with Unmatched Queries


G

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
 
Ad

Advertisements

J

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?)
 
Ad

Advertisements

G

Gary Crisp

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top