show records from Friday when working on monday

[webisti]

Hi guys

I am stuck with a query results:

a table is being updated every day. Table name is "Process".
basically on this table I am appending all the orders inserted from clients since Friday, and on other days just insert the orders from the day before:
On the Orderdate field of the pending query
I do have this criteria:

Between IIf(Weekday(Date())=2,(Max(ORDER_DATE]))>=Date()-3,Date()-1) And Date()-1

but is not working. instead of just appending the last Friday`s data on Monday it is inserting everything..
How should I modify it in order to have just the last Friday.


Any ideas on this issue.

thanks a lot

Webisti

[June7]

There are orders on Sat and Sun to be captured as well?

I don't understand the use of Max(). Max() is an SQL aggregate function. I am surprised anything is inserted with this.

Try:

BETWEEN Date() - IIf(Weekday(Date())=2, 3, 1) AND Date()-1

Why do you have to do this? If records are already in db, why aren't they already in the appropriate table?

[webisti]

Actually This table is base for a split form that should show Date()-1 orders.
There are also orders with a future date but I want them not to sh0w therefore the criteria is date().
but if that should happen in Monday they it must show also what has been received also during the weekend.
I will try your version.. thanks June