Re: How to create a form based on a crosstab query? (I don't know how many columns there will be!)
- From: Roger <lesperancer@xxxxxxxxxx>
- Date: Tue, 29 Apr 2008 03:07:37 -0700 (PDT)
On Apr 29, 2:33 am, Paul H <goo...@xxxxxxxxxxxxxxxxxxxxxxxx> wrote:
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
assuming that there will be a maximum of 12 months
edit the query, hilight the column heading field, I assume it is
called 'months' and show its properties (right click the column)
in the 'column headings' property add
"month01", "month02", ..., "month12"
this will cause the query to already have 12 columns regardless of
which, if any, have data
.
- Follow-Ups:
- References:
- Prev by Date: How to create a form based on a crosstab query? (I don't know how many columns there will be!)
- Next by Date: Create a single-record append query without warnings on duplicates
- Previous by thread: How to create a form based on a crosstab query? (I don't know how many columns there will be!)
- Next by thread: Re: How to create a form based on a crosstab query? (I don't know how many columns there will be!)
- Index(es):
Relevant Pages
|
