Create a table CountNumber with field CountNUM containing numbers 0 (zero)
through 6.

SELECT YourTable.*
FROM CountNumber, YourTable
WHERE ((([SomeDate]) Between (Date()-Day(Date())+1)+[CountNUM] And
(Date()-Day(Date())+1)+[CountNUM]-6) AND
((DatePart("w",(Date()-Day(Date())+1)+[CountNUM]))=4));

--
Build a little, test a little.


"116" wrote:

I am trying to create a query to give me the results from the first weds of
each month back to the following day after weds. Having trouble formatting
the Date function.

Any help would be greatly appriciated.

Thanks
David