How to create a form based on a crosstab query? (I don't know how many columns there will be!)

I want to base a form on a crosstab query. The query shows statistics
for a user defined period. The column headings will look something
like this:

ClientID Month01 Month02 Month03 etc..

So if the user selects 3 months in the criteria form, there will be 3
(month) column headings, if he selects 6 months, the will be 6
headings.

At the moment my solution is to somehow (i haven't figured out the VBA
yet) construct a form dynamically. Is there a simpler solution to this
problem?

Thanks,

Paul
.

Relevant Pages

  • Re: Dynamic Reporting based on Parameterized Crosstab Query
    ... Since the column headings are all dates at a regular interval, ... charge date charged hours are associated with. ... on the first 3 rowwise fields of the crosstab query. ...
    (microsoft.public.access.reports)
  • Re: how to generate a report from Form output
    ... Headings property of the crosstab query. ... A crosstab query has a Column Headings property. ... make out a report with these elements, i tried to create a plain ...
    (microsoft.public.access.reports)
  • RE: Dynamic column in report using crosstab query
    ... H. Frank Situmorang ... "Duane Hookom" wrote: ... Crosstab query that John suggested is a bit extraordinary. ... You need to use a reference year to calculate your column headings. ...
    (microsoft.public.access.reports)
  • Re: Crosstab Help
    ... I would create this with a crosstab query. ... dates as column headings, use "relative" dates. ... "Jason Sweet" wrote in message ... >>Duane Hookom ...
    (microsoft.public.access.queries)
  • Re: Report casues crash
    ... Open the crosstab query in design view. ... List the possible values for the column headings, ... Thanks for the info ans steps to solve my report crashing problem. ... a crosstab query gets its column headings from one of the ...
    (microsoft.public.access.reports)