crosstab date issue

[llaman]

I am trying to run a crosstab query that has the row heading of project name,
hours as the value (sum aggregate function), and a column header of entrydate.

I have the entry date formatted as mm/yyyy, but it is initially entered with day. When I run the crosstab, it makes a seperate column for each day, instead of by month. Is there a way of fixing this without losing data accuracy (i.e. turning the data from 05/01/04 to 05/04)?

 

[Norie]

Say your date field is called DateField, you could try this:

MonthYear:Format([DateField], "mm") & "/" & Format([DateField], "yy")

You could do this in a select query then use that query as the source for the crosstab.