I
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
[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