crosstab query in a form

[David Coit]

I have a crosstab query that I would like to show in a
form. The columns are going to change based on this query
so that will not allow me to have a bound set of fields.

How do I get this to happen

 

[Michel Walsh]

Hi,


If you have a recent Access version, try to use a Pivot Table,
rather than a crosstab (such as in the form SalesAnalysis in Northwind).
Much cooler than the beige crosstabs... for presentations.



Hoping it may help,
Vanderghast, Access MVP

 

[Michel Walsh]

Hi,


I should have said "Sales Analysis" form.


Vanderghast, Access MVP