Reports based on start and end date?

A|ex

Registered User.
Local time
Today, 23:09
Joined
Jul 11, 2004
Messages
90
How do i make a report prompt a start date and finish date based on a table field to which it should pull data/rows from?
 
base your report on a query rather than from the table, and place the prompts in the criteria section of your query!
 
my report is based on a query i was just wondering how do i get it to prompt
 
in the criteria section of the your query put the following under the startdate and enddate fields:

[Enter Start Date]
[Enter End Date]

put the above in one row under the start and end date fields
 
is it possible to add a mask to the input? how do i display a error message if no records are found?
 
A|ex said:
how do i display a error message if no records are found?

since you are using a Report you can use the On No Data event of the report!
 
where is this option? at the moment i cant seem to get the start and end date working correctly? i look at the order entry example and i cant see what i am doing wrong?
 
Alex, I usually want the date criteria to show up on the report some where so the user knows what the date range is for the data they are looking at. Is this something you think your report needs?

ken
 
the problem is it isnt pulling or showing any data no matter what date you enter
 
Did you put something like this in the criteria for the date?

Between #[Start Date?]# and #[End Date?]#

???
ken
 
Between #[Start Date?]# and #[End Date?]#

Doesnt work
 
managed to get it working

Between [Start Date] And [End Date]

thats what was needed :)
 

Users who are viewing this thread

Back
Top Bottom