reports preliminary basic questions

[azzi2000]

OrderTable: id, name, orderdate, qty, unitP, ....

I have a simple reports that I would like to ask to list a range of order: beginning date and ending date.
a) How can I introduce the paramter to be linked to the report.
b) If the user enter no date I would like to get all
Please advice,
Dré

 

[PaulF]

Create a query that uses the Order Table, add the appropriate fields to the QED, next Select Query-Parameters from the Main Menu and enter
Enter the Beginning Date
for the parameter and select Date/Time as the Data Type,
On the next line add
Enter the End Date
for the parameter and select Date/Time as the Data Type, then click OK to close the parameters dialog box
on the Criteria row for the OrderDate field add

Between [Enter Beginning Date] And [Enter End Date]

Next add a new field like this
Exp:[Enter the Beginning Date]
and set it's Show Property to False
on the 2nd Criteria row (so its an "OR" condition not an "AND" condition) add
Is Null
save the query and then use it as the RecordSource for your report. Then when the report opens the users will be prompted to enter the data, and if left blank, will show all records

PaulF

 

[azzi2000]

Paulf:
Thank you.
dré