help to create variables record sources.

  • Thread starter Thread starter Marco
  • Start date Start date
M

Marco

Hi.

I need to build a report over a query. but my problem is that the columns
colums source are not fixed.

imagine: if I have choose the January option from a combobox on FormA I want
that the column A in report gets me the query column YTDDecember, but if I
choose the option on form September I that the column get me the query column
YTDAugust.

How can I do this? should I have a table or something? to put this type of
information?

Regards,
Marco
 
Why not fix your column name(s)? If you can't figure out how to do this, you
will need to provide some significant information about your table structure
and specifications.
 
To "provide some significant information about your table structure and
specifications" you would simply type information about what you have and
what you need. If you don't tell us where you are and where you want to go,
we can't help you get there.
 
Is this a crosstab query which you want to filter so that you only show one
month in your report?

Is there any connection between the month you choose and the data in a field
in your report (hopefully a date field)?
Are you talking about only one Column Header 'label' or a whole row of them?

Does your combo box have a number column as well as a month name?

Evi
 
Back
Top