I have a query that asks for the date range. It promps for the beginning date and the ending date. This query works fine. I use this query for a report.

How do I get the date range to print on the top of the report? I want it to show beginning date and ending date. When I use the field "date received" and put in on top of the report, it only shows one of the dates.

I want it to look like this on the top of the report: Between "beginning date" and "ending date".

I am sure this is something simple, but I am having brain lock.

Thanks!

In your query do you select the dates with acronyms eg 'as DateFrom'

If so use these acronyms as the control source of the fields on the report

eg

Select tblnames.name, tblnames.dateofbirth as DOB, tblemployment.employeddate as DOE from
tblnames innerjoin tblemployment on tblnames.nameid = tblemployment.empid ;

Hope this helps.
Tony

Claudia

You might also want to look at the post entitled: "Date Pop-up before Query Runs"
on the same page as your post.

Tony

Sorry that I haven't responded till now. Have had a very busy week.

My report is connected to a query. In the criteria range under the date field I have the "between [beginning date] and [ending date]".

I have been reading my book and think I may have found a way to have it list the date on the top of the report.

I would appreciate any advice you can give me. I basically work with queries. Trying to learn more.

I really appreciate all the help I have gotten in the past.

Thanks again!

Set up a Text Box on your report. In "Control Source" (data tab) put somthing like

="Widget Sales for the period "+[Beginning Date]+" to "+[Ending Date]

I put [Start Date] and [End Date] in most of my queries as it is easier to use in reports without th e"ing" at the end.

Suppose that these dates come from [SaleDate] in the WidgetsSold table. Then you could also put on you report Max([SaleDate]) and Min([SaleDate]) Just depends what the people using the report want and how your data is set up.

Thanks, it works! I did have to take the dates out of the criteria in DateReceived field or it asked for the date ranges twice in the report.

I do have a question that may sound silly. When I put the information in the text box how does it know that I am asking for the dates in the DateReceived field of the query?

Thanks again.