Re: week

From: PC Data*** (nospam_at_nospam.spam)
Date: 12/10/04 

Date: Fri, 10 Dec 2004 23:40:20 GMT

In your query, put this expression in an empty field:
PaymentDateWeek:Format([Payment_Date],"ww")
Put this expression in the criteria:
Format(Date(),"ww") 

--
                                        PC Data***
Your Resource For Help With Access, Excel And Word Applications
                              resource@pcdata***.com
                                 www.pcdata***.com
<jjrmy1@earthlink.net> wrote in message
news:55nud.7456$0r.5317@newsread1.news.pas.earthlink.net...
> Hi. I have an access 2000 table named payments and would like to select
all records in which the date in field payment_date falls
> within the current week.
> I would much appreciate any help as I have never worked with weeks in a
query before.
> SELECT * FROM payments WHERE payment_date = DATE(ww)
> is this correct
> thanks a bunch for your help!
>
>