As of Today Report 1

[dvannoy]

Is there a way to use the system date to create a report and ask for a date range for the week...

I need to go off the actual real date not any date fields in my database...

eg..i need to know like this monday through this fiday we did this with this product and did that with the other..

is that possible of do i have to create a field called date and have it insert the current date into that field eveytime a record is created??

Thanks

DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[LonnieJohnson]

Create a query. As criteria for the date in question. Put this...

Between DateAdd("d",-(Weekday(Now())-1),Now()) And DateAdd("d",7-(Weekday(Now())),Now())

This will pull everything for the current week. ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV