Query to convert table

[BroncoMarc]

I have an existing table that currently looks like this:

Product     Month Number     Sales
cogs             1             245
cogs             2             324
sprockets        2             352
sprockets        1             123

I want to use a make table query to convert the table to something like this:

Product         Sales Month 1       Sales Month 2   Sales Month 3  ....
Cogs               245                    324              0
Sprockets          123                    352              0

Is there an easy way to do this?

Thanks,
- Marc

 

[dcx693]

Sounds like you need a crosstab query.

 

[BroncoMarc]

Thanks.. that worked..

When I use a crosstab query in another query, will it update the columns if I try to change the design next month, or will I need to remove the table and re-add it?

 

[dcx693]

will it update the columns if I try to change the design next month

Depends on what you mean. If you just add data to the table, the query should update fine.