How to create an indexed field in a union query?

[jcemanic]

good day to all!!

just like to find out how could i create an indexed field in a union query in Microsoft Access??
i have a problem linking a query with a table in my report (using Crystal Report to create)....


thanks for all the help!
from jcemanic

 

[JoanneM]

Hi there provided that the fields you are sorting on are both indexed in there source query the final stage is to put your UNION query in another query and sort the index there. Just checked it and it works fine


regards

jo