Get Values From Crosstab Query

[Guest]

I am designing a 1-page crosstab report to show the sales of the top 7
products to 15 customers. On a month-to-month basis, different products will
be top sellers. The column labels and the control source of the seven sales
textboxes will need to be dynamic. How do I get the names of the seven
products from the cross tab query to dynamically assign the column labels and
control sources of the textboxes in the report's open event?

Thanks!

 

[David Lloyd]

Martin:

The following KB article may be a good reference, depending on your
circumstances.

http://support.microsoft.com/kb/328320/en-us

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I am designing a 1-page crosstab report to show the sales of the top 7
products to 15 customers. On a month-to-month basis, different products will
be top sellers. The column labels and the control source of the seven sales
textboxes will need to be dynamic. How do I get the names of the seven
products from the cross tab query to dynamically assign the column labels
and
control sources of the textboxes in the report's open event?

Thanks!