"Susan" wrote

is it possible to link queries to create a report?
if so how would i do this?

What do you mean by "link queries"?

If you have multiple queries with additional information about the same
subject (a customer, say), that is, in Access parlance "join"ing those
queries. That is what Steve's answer addresses.

If, on the other hand, you have multiple queries with the same information
about different subjects (many customers, say), then you need to "UNION"
those queries... all the queries in a UNION must have consistent format for
the data in the same column. Check HELP for UNION and UNION ALL. Sad to say,
this feature is only avaiable in SQL view of the Query buider; no visual
option. But, happy to say, it is really quite simple SQL -- you can copy and
paste most or all of it, and just add the UNION or UNION ALL commands.

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access