report based on a crosstab query

[Ivor Williams]

I've created a crosstab query in which row headings are a project number
[ProjNo], column headings are dates [Date] and each of the data fields has a
number of hours.

I built a report based on the query which worked perfectly until I wanted to
change dates. The date field in the report by default uses the actual date
value as a data source rather than the field [Date], so if the date is
different, the report doesn't recognize the new dates. How can I work around
this? Is there a way to 'reset' the dates in the report?

Ivor

 

[Guest]

Are you always printing consecutive? Are there a specific number of dates? If
not, you may need to use the dynamic crosstab report solution found at:
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

If your dates are consecutive, use relative dates as column headings.