Query not pulling at all

[ricardo9211]

hello all,


i am fairly new to access and am currently trying to create a simple query that finds all the unmatched data but when i run it it displays nothing. i have 2 spreadsheets that are linked in and am running the query off them. there is nothing else to the data base. I am not sure what all information you will need to help me with this issue but can someone start me off on a path to getting this resolve

Thanks

[maximus]

To start of with the feild names and datatype ten the criteria of the query that you are trying to run is required to provide a reasonable solution.

[ricardo9211]

There are 7 fields; Site, Team, Agent, Date, Description, Start Time and End time. all text all data type text . I am running a query to find unmatched rows from one to another table. using the agent field as the match for both tables.

Just looking at the tables alone one has 189 more entries. so theoretically when i run the query i should have 189 entries. but it will just not give me any information.

[maximus]

I will assume that when you say matched you mean to say that you have linked the agent field in the two fields.

Then assuming that you have two table one at the left hand side (Table1) the other to the right hand side(Table2) then linking the agent field of the two fields will return the following result:

All entries in Table 2 that has the same agent in Table 1 and all entries in Table 1 that has the same agent in Table 2.

you will have to learn about different joins follow this link
http://www.w3schools.com/sql/sql_join.asp
if you can't solve your problem import the excel sheets onto a Access database and upload it I will check it out.