unmatched query

[jaggy12]

wonder if somebody can help
I have two talbes. similar information but the number (count )of data is different. I used Unmatched query to find out discrepancy.. but here is my probelm.

table1 100 100 150 200 300
table2 100 150 200 200

when I run the query, it only shows 300 from table 1.
But I need to a result showing 100 from table 1( becuse table 2 has one of 100) and 200 from table 2( since table one only has one of 200)

So when I used unmatched query, I have not the result what I want...

Appreciate any help

Thanks

 

[lespaul]

the unmatched query wizard will return 300 because that's the only "unmatched" record. There's a 100 in both tables, there's a150 in both tables, there's a 200 in both tables, there's a 300 in only one table - therefore there is no match.

I'm guessing what you want to know is how many extras there are in each table? So there's an extra 100 in table 1, an extra 200 in table2. But you wouldn't want to return the 300?

leslie

 

[jaggy12]

No actually I need to get returned 300 too. But I also want to get returned 100 and 200 each too ( the unite does not match between two tables. ) I am guessing I cannot use unmatched query..

But is there any way that I am able to get the results what I want?


Thank you for help .. and appreciate more help...

jaggy

 

[PHV]

get the results what I want
What do you want with which data ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dhookom]

Create a couple totals queries that group by the field and count the field. Then use an unmatched query to find out where the records and counts don't match.

Duane
Hook'D on Access
MS Access MVP