Date parameter

  • Thread starter Thread starter Eugene
  • Start date Start date
E

Eugene

Hi all

I have a query where I extract data from a database for technical
problems logged the previous day. Currently I use the parameter
function to enter date ranges in the query (>=[start date] and <[end
date]).

Is there any way in which I can automate the date parameter so that
when I run the query it will automatically use the previous days'
date. I tried "Now()-1" but that didn't work. Basically, the
function will have to automatically get the previous days' date. (If
the query is run on a Monday, it must use Fridays date...basically the
previous working days' date).

Anyone know of a function in Access that can do this? This will
really help me a lot. I probably searched half of the net for answers
but haven't been succesfull. :)

Regards
Eugene
 
Back
Top