Hello:
  Here is my problem. I have two different queries, where both, by intention, have the same field names. I need to take those two different queries and merge the information in to one query.

  One query takes information about books and courses. The other query takes information about software and courses. Now, they need to be merged into one massive query and I'm not sure the best way to do it. The reason I have them have fields with the same name is because the software/course table doesn't have all the information that the books/courses does, so I have the software/course query generating empty fields in the appropriate places.

  Any help is appreciated.

Best Regards,
Arholly

Hi Arholly

Use a union query. it would go something like this

write your select query here for example
SELECT [NAME],ADDRESS FROM TABLE

UNION SELECT [NAME],ADDRESS FROM [OTHER TABLE]

and run the query. this will combine both your tables