Unmatched Query Problem/Question Please

[anchorp]

Is it possible to create an unmatched queary between two tables that do not have unique keys, but instead use a combination of two columns that would be unique (for example date and trans# where trans# is unique per day)?

Both tables have both columns, date and trans#.

If this is possible please help me understand how to do it. I only know how to use the standard unmatched query wizard and it seems to only compare one column.

Any help is very appreciated.

 

[pbaldy]

The wizard will just do one column, but you can add a join between the other 2 fields when it's done. Make sure it's the same type as the one created by the wizard.