Update Dates on Report from users entry

[ZZSteele]

I have a report that was built off a Crosstab query. Everything works great, but the dates are static. The crosstab query pulls the information based on a date range a user enters.

So, when I built the report the dates ranged from 3/04 - 10/04. If a user wants to pull information from any other time, the report will not allow it. I tried to put an unbound text box in the area instead of the dates and build it to a query with the dates, but the field was not recognized.

 

[Andrew Fergus]

Hi

If I am reading your question correctly, this can be done but it takes a bit of set-up. What you are seeking are fixed headings on your crosstab report but the values of the headings change depending on the users selection. It looks like this question relates to your previous post on the underlying query.

I answered a similar question in this post but be aware there was a bit of toing and froing to get that one working.

HTH, Andrew.

 

[daknight]

Hope I understand your question correctly; you are trying to get the date parameters entered by the user to show up on your report?
Try this: text box on page header:
="Between " & [Type beginning date] & " and " & [Type ending date]
Darla