Hi,
I have a database which I am looking to use a crosstab query which will populate the data for a report. The report data (column headings) will be products and dates which the user can select from a form, so the column headings will change depending upon the date range selected (max 7). I have uploaded an example with sample data I have used fixed dates (not from the form) for this example, however my issues is that I cannot work out how to get the query to change the date column headings (which could be any date) to pull through to my report on fixed headings if this is how it would be done.
I'm sure I have achieved this a few years ago, however cannot remember or see how to do this now.
Many thanks in advance for your help!!
Malcolm
I have a database which I am looking to use a crosstab query which will populate the data for a report. The report data (column headings) will be products and dates which the user can select from a form, so the column headings will change depending upon the date range selected (max 7). I have uploaded an example with sample data I have used fixed dates (not from the form) for this example, however my issues is that I cannot work out how to get the query to change the date column headings (which could be any date) to pull through to my report on fixed headings if this is how it would be done.
I'm sure I have achieved this a few years ago, however cannot remember or see how to do this now.
Many thanks in advance for your help!!
Malcolm