Reports based on start and end date?

[A|ex]

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?

 

[maxmangion]

base your report on a query rather than from the table, and place the prompts in the criteria section of your query!

 

[A|ex]

my report is based on a query i was just wondering how do i get it to prompt

 

[maxmangion]

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

 

[A|ex]

is it possible to add a mask to the input? how do i display a error message if no records are found?

 

[maxmangion]

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!

 

[A|ex]

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?

 

[KenHigg]

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

 

[A|ex]

the problem is it isnt pulling or showing any data no matter what date you enter

 

[KenHigg]

Did you put something like this in the criteria for the date?

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

???
ken

 

[A|ex]

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

Doesnt work

 

[A|ex]

managed to get it working

Between [Start Date] And [End Date]

thats what was needed