Typically you don't need to create a new table. Just use queries unless
there is some compelling reason why you can't.


--
Duane Hookom
MS Access MVP


"Mickey" wrote in message news:2010051718170216807-oik@mecom...
Hi,
New to Access and have inherited a database at work, I need to create some
crosstab queries and am unsure if I would be better off creating a new
table from a query to hold the data for the crosstab query or is it okay
to run a query and then use a crosstab query on that first query?

The crosstab query appears to work fine when using the initial query as a
source but can someone advise me if that is okay to do?

Thanks,
Mickey