Gordon
Gordon
- Local time
- Today, 11:22
- Joined
- Nov 25, 1999
- Messages
- 34
Hello,
I have a report which is based on crosstab query. One of the fields in the query is "date" current range is "Between #7/1/2007# And #7/1/2008#"
Dates are not part of the column or row headings. The date field is there just to limit the range of data which is chosen.
I would like to do two things with this: (1) I would like to show the date range in the report header. However, the "date" field is not a choice in the pull down menu of available fields to include in the report.
(2) I would like the users of the report to be able to choose their own date range, which I have done with other reports by using "between.... and.." statements in the query. "Between [What is First Date] And [What is Final Date]."
I did try puting a text box in the report header, bound to the field in the query as follows: "=qry_rpt_dog_bike_violations]![Date]" but came up with an error message.
Thanks for any help!
I have a report which is based on crosstab query. One of the fields in the query is "date" current range is "Between #7/1/2007# And #7/1/2008#"
Dates are not part of the column or row headings. The date field is there just to limit the range of data which is chosen.
I would like to do two things with this: (1) I would like to show the date range in the report header. However, the "date" field is not a choice in the pull down menu of available fields to include in the report.
(2) I would like the users of the report to be able to choose their own date range, which I have done with other reports by using "between.... and.." statements in the query. "Between [What is First Date] And [What is Final Date]."
I did try puting a text box in the report header, bound to the field in the query as follows: "=qry_rpt_dog_bike_violations]![Date]" but came up with an error message.
Thanks for any help!
Attachments
Last edited: