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