Hey all,
I have a crosstab query that references a table and calculates a sum based on the value of the feild in the table.
how do I get it so that my crosstab will display every date in a month (i.e. June 1st to June 31st) where the month is entered in through a form.
For example if my table is missing data for June 21st the query will display with zeroes in all fields.
thanks in advnce
Gary
p.s. i have noticed some solutions for each month in a year, but nothing to dynamically return dates based on form entry