find week dates

I would like to create sql that retrieves all records where the date in payment_duedate falls within the current week
sun. thru mon. I have never worked with weeks before and have looked everywhere for some help to no avail.
here's an example of what i'm trying to do, to give you an idea, but this doesn't work.
SELECT * FROM payments WHERE payment_duedate = (Now(), "ww")
thanks for the help

never mind I think I found it
SELECT *
FROM payments
WHERE payment_duedate = Date() - WeekDay(Date()) + 1
AND payment_duedate = Date() - WeekDay(Date()) + 7

Here's another way:

Put the following expression in a blank field in your query:
WeekOfPaymentDueatePart("ww",[PaymentDueDate])
Put the following expression in the criteria of that field:
DatePart("ww",Date())

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com


wrote in message
news
I would like to create sql that retrieves all records where the date in
payment_duedate falls within the current week
sun. thru mon. I have never worked with weeks before and have looked
everywhere for some help to no avail.
here's an example of what i'm trying to do, to give you an idea, but this
doesn't work.
SELECT * FROM payments WHERE payment_duedate = (Now(), "ww")
thanks for the help