I have a query with critera in the date field ( Between [Type the beginning date:] And [Type the ending date:] )
I want to create a chart from the data in the query, and display the date range at the top of the report. I have had no success.
I tried: Creating a report based on the qry. Then inserting a chart based on the same query. Then a text box w/ ( =[Type the beginning date:] & " to " & [Type the ending date:] ) at the top of the report.
When I try to view the report it ends up asking me for the start and end date several times? Can I make a report using the chart wizard? But then how do I display the criteria?
I hope all this makes since. Thanks for the help.