Hi

I am using a SQL server back end to access front end

can i create union queries in SQL server, or do they have to be done in an access front end

many thanks

sorry, for wasting time here

i got confused form the initial response message in sql server. i indeed can create a uinion query and have now acheived what i wanted