MINUS in MS Access

[dbadmin]

Access Gurus,

Can I use MINUS operator in MS Access queries? I need to find the difference between two tables.

dbadmin

 

[sfreeman]

Be more specific please.

Sam_F
"90% of the problem is asking the right question.

 

[Trendsetter]

It depends what differences you are trying to detect!
Minus works in a calculated field.
Give us a bit more to go!

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[dbadmin]

Thanks guys. My tables are of the same structure. I need to find only the data difference between them. I can use exists statement in a query and run it, but can I use MINUS operator?

dbadmin.

 

[sfreeman]

Still do not know what you mean....

Have you tried a standard 'Find Unmatched' query???

Sam_F
"90% of the problem is asking the right question.

 

[Trendsetter]

I don't think Minus is an option because that executes and action whereas you are seeking the differences - we still don't know what you are trying to differentiate!

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk