Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Totals Query - Report Help 2

Status
Not open for further replies.

tpearo

Technical User
Joined
Apr 24, 2000
Messages
124
Location
US
I have a report based on a totals query in my database that reports the quantities of defects and types of defects identified during inspection of a product. The totals are based on a date range. I'm a little lost on how to get that date range to print on the report. The condition of the field for the date range is "where" [Enter Begin Date] and [Enter End Date]. I need the two dates to print on the report to illustrate the time frame for the defects.
Can anyone help???
 
If you input these dates from a form, which then launches the report, you can put 2 text boxes in the report header, and then make them look at the fields on the form.

James.
 
add the following code =[Enter Begin Date]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top