criteria

[linux44]

hi
i have created a database for attendance register and need to create report for it
before produce report it should ask you the date like say from when to when

example of it you would put from 10/10/2008 till 20/10/2008

my problem is in query ,in criteria i can put "[enter date]"but iw would only ask for date once.
how would i define that ask me a starting and ending date?
thanks

 

[Rabbie]

Try
Between [enter starting date] and [enter ending date]

 

[linux44]

it is not working

 

[neileg]

In what way is it not working?

 

[linux44]

it ask you for starting and end date but it wont bring up any details

 

[Yecats131]

http://office.microsoft.com/en-us/access/HA100963141033.aspx?pid=CH100645771033

That link may help you out... its a tutorial on doing this. Make sure that you have the parameter setup under the currect section - IE The date section.

Also, make sure that you are running the query for a date range that you have data entered for. IE if you have 2 dates, 3/10/08 and 3/11/08 and you are running it for a range of 4/10/08 - 5/10/08 it will not pull anything up.