crosstab

[Mickey]

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

 

[Duane Hookom]

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