The difference between two queries

[johnsaw]

I have two queries made up of the same fields. What i need to do is get all the records in the first query that don't appear in the second. The only problem is there isn't one unique identifier you need to use two fields to identify records the same. I cannot work out how to use the unmatched query for more than one field.

 

[KKilfoil]

Have a look at the "find unmatched query wizard"

 

[johnsaw]

This doesn't work unfortunately, well i cannot work out how do do it because it is dependent on two different fields and not one.Both need to be identified together otherwise some records will be omitted. Both fields together will uniquely identify a record, but seperately, or one after another they will remove records which shouldn't be.

 

[Pat Hartman]

Add a calculated field to each query. This field will concatenate the two key fields. You can then havt the unmatched query wizard use the concatenated field.

Select ..., FldA & FldB As CatFld

 

[johnsaw]

Yeh cheers that worked fine.