How to display a field across

[Don]

I have a customer database with monthly sales totals for each customer. Each
month is a new record for each customer.

I want to be able to show a customer's sales across my report. This means
that my field for sales would have to be used 12 times across the report,
once for each month of sales data.

How can I do this? How can I do it to show only the closed months for the
current year. For instance, I have closed sales for Jan through October for
2006. So there will be only 10 months of columns on my report.

If I create a crosstab query, when I update my sales information, the old
query won't work. Any help would be greatly appreciated. Thanks...

Don

 

[Marshall Barton]

I have a customer database with monthly sales totals for each customer. Each
month is a new record for each customer.

I want to be able to show a customer's sales across my report. This means
that my field for sales would have to be used 12 times across the report,
once for each month of sales data.

How can I do this? How can I do it to show only the closed months for the
current year. For instance, I have closed sales for Jan through October for
2006. So there will be only 10 months of columns on my report.

Depends on how your data is structured. If it's normalized
with the sales data in its own table with a single record
for each sale, then I think you should use a subreport set
to 12 columns (Across then Down).

 

[Don]

Thank you. It is one field for sales. I will take your advice--it makes
sense to me.