How to display a field across

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Don said:
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.
Click to expand...


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).
 
Back
Top