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" <(E-Mail Removed)> 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
>
|