Hello,
I would like to put the first date shown in my query in my report header as well as the last date. For example the Header would read Report covering 1/5/06 to 4/17/06, and would automatically update depending on the first and last dates in the query. I used =First([date]) and =Last([ Date]) in two text boxes in the report header but it did'nt show the correct dates. The report is a summary report. Is what I want to do possible?
I would like to put the first date shown in my query in my report header as well as the last date. For example the Header would read Report covering 1/5/06 to 4/17/06, and would automatically update depending on the first and last dates in the query. I used =First([date]) and =Last([ Date]) in two text boxes in the report header but it did'nt show the correct dates. The report is a summary report. Is what I want to do possible?
