Need help with a report from a query

[sizemoreg]

I'm trying to run a report based on a query, where my results will show the previous day. What need is to have the report show Friday's results, when I run the report on Monday.

I need to set this up so that they people using this report (not tech savvy at all) can just click a button to run a macro for this query.

I created the query to have a pop up window asking for the day, but as I said, the folks using this just don't get to the concept of just enter the day you want, so I am tasked with making this a dum as possible for them.



I can get =date()-1 to work and grab results for the previous day

I tried =networkdays()-1 with no success

I'm not an access guru by any measure.

could someone point in the right direction? This report is run daily, so I need it to capture the previous day and to capture Friday, when run on Monday

Any help Thanks in advance

[bewsh1987]

hi Try this - IIf(Format(Date(),"dddd")="Monday",Date()-3,Date()-1)

[Micron]

Would it matter if Monday was a holiday?

[bewsh1987]

Would it matter if Monday was a holiday?

I agree you could have a secondary query for Monday holidays
IIf(Format(Date(),"dddd")="tuesday",Date()-4,Date()-1)

[sizemoreg]

Worked, thank you so much