Access: Day of week query [Resolved]

[RobDog888]

I need to create a query where it will take a field and place that value
into some fields based upon were that related date field fits into
the next 4 dynamically calculated Mondays.

So basically I need to be able to calculate from the current day
the current weeks Monday and the next 4 Mondays after that
and alias those fields as below. Then compare the records date
to where it would be less than the aliased fields but not less than
the previous Mondays date.



Ex. convert hard coded dates to dynamic IIFs somehow.

Table1:
PO = Text; dDate = PO's Date

PO      dDate
----------------
222.01  11-05-04
333.05  11-12-04
111.01  11-21-04
444.01  11-23-04
555.02  11-30-04

Report:
PO       11-08-04     11-15-04     11-22-04     11-29-04     12-06-04
---------------------------------------------------------------------
222.01   100
333.05                150
111.01                             200
444.01                                          1000
555.02                                                       50

Thanks for any assistance on this.