Using Multiple Fields to Create Unique Key

[dzdncnfsd]

I have two tables that I have to join in a query in order to create a printable customer payment history. They each have the same two fields that together make one unique value. Neither of the fields are indexed in either table, so when I join each field to its counterpart in the other table and run a query based on the combination, it takes forever to complete. I can't make changes to the underlying tables, or I would combine the two fields and create a key field. Does anyone have any suggestions?
Thanks for any help you can give me.
Gladys


Gladys Clemmer
gladys.clemmer@fifsg.com

 

[DreewToo]

If the tables aren't too large, perhaps importing them into Access, making temp tables of them and assigning index, and running the reports from there? I think it might take less time to perform and could be done with modules or macros.

HTH,
Drew

 

[dzdncnfsd]

Thanks for the suggestion, but I don't think it will work because one of the tables is a linked SQL 7.0 table and gets over written every day with fresh data. I need to be able to do this in the existing query.
Thanks,
Gladys

Gladys Clemmer
gladys.clemmer@fifsg.com

 

[dzdncnfsd]

The fix turned out to be simple. The problem was that I had set my joins incorrectly. Problem solved.%-)
Thanks.

Gladys Clemmer
gladys.clemmer@fifsg.com