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