Hi all,
I am trying to make a crosstab query with a date range as the column heading. My 'Shipments' table contains a field called 'Despatch_Date' and I would like the crosstab query to use this data as the column heading starting from today's date through to the maximum date in the data. However, the data does not have consecutive dates and will have some gaps. What I would like is for the missing dates to also appear in the column heading.
I found the below thread and post #5 shows a public function to generate the IN list for the column headings. I don't know if this is a possible solution...?
https://www.access-programmers.co.uk/forums/threads/dynamic-crosstab-report.242545/
Thanks for your help.
Chris
I am trying to make a crosstab query with a date range as the column heading. My 'Shipments' table contains a field called 'Despatch_Date' and I would like the crosstab query to use this data as the column heading starting from today's date through to the maximum date in the data. However, the data does not have consecutive dates and will have some gaps. What I would like is for the missing dates to also appear in the column heading.
I found the below thread and post #5 shows a public function to generate the IN list for the column headings. I don't know if this is a possible solution...?
https://www.access-programmers.co.uk/forums/threads/dynamic-crosstab-report.242545/
Thanks for your help.
Chris
Last edited: