Does anyone know if there is a Month formula that you can use when designing a Query?



I have an assignment to do that states..."Create a Sales by Product by Month report for data that has been given. You should have one row for each product and 1 column for each month. Feed this crosstab query to a report so that you can provide totals to the right and totals at the bottom of the report".

The data given does not have any Table that has a Month field (i.e., a field that displays all the months of the year)

So my question is whether or no there is a formula that I can use when making the Query in order to display all the Months of the year.

Thanks