Finding files that don't match

J

Josh

I have two excel files that I've imported into Access. One has titles that
the other doesn't. How do I create a query that shows the non-matches?

Thanks,

Josh Axelrad
[email protected]
 
K

KARL DEWEY

Titles of fields do not have to match do run an unmatched query, just make
sure they are the same datatype.
 
J

Josh

Karl,

I don't understand. I am looking to run a report that tells me titles XYZ
from file A are not showing up in File B. Is there a tutorial online that
will show me how to do this?
 
K

KARL DEWEY

We need to clarify terms that you are using as I thought your were just
calling Access object by the wrong names.
To be a 'file' is an electronic document in a 'folder' that is stored on/in
a 'drive' that is either a 'hard drive', 'network drive', or 'removable
media' like a 'floppy disk', 'zip disk' or 'thumb drive.'
Access data is stored in a 'file' called a 'database file' with file
extention of .mdb. Within the database are tables that have fields
(horizontal) and records (vertical) storing the data.
Are you talking about electronic files or Access databases?
 
Top