week

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Okay, try this:
create a field in your query like this:
Date1: Format([YourDateField],"ww")
In the criteria enter this:
Like Format(Date(),"ww")
Create another field (to limit to just this year):
Date2: Format([YourDateField],"yy")
In the criteria enter this:
Like Format(Date(),"yy")

Does it work?


Hi. I have an access 2000 table named payments and would like to select
Click to expand...
all records in which the date in field payment_date falls
 
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 Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


Hi. I have an access 2000 table named payments and would like to select
Click to expand...
all records in which the date in field payment_date falls
 
Back
Top