difference of dates

G

GregB

How can I check for entries made during the last week, what would I put in
for the query. I do have a field where it stores the date.

Also how would I get a report for all my data broken down into weeks?
Week of 8/1
week of 8/8
etc.


Thanks,
Greg Blanche
 
J

John W. Vinson

How can I check for entries made during the last week, what would I put in
for the query. I do have a field where it stores the date.
Click to expand...

There are a number of date handling functions built in to Access. Just what do
you mean by "the last week" - Monday through Friday? Sunday through Saturday?
Monday through Sunday? To get all records from Sunday before last through last
Saturday, you can use a query criterion of
= DateAdd("d", -8 + Weekday(Date()), Date) AND < DateAdd("d", -1 + Weekday(Date()), Date())
Click to expand...
Also how would I get a report for all my data broken down into weeks?
Week of 8/1
week of 8/8
etc.
Click to expand...

Take a look at DatePart("ww", [datefield]) - it will give you the week number
of the year.

John W. Vinson [MVP]
 
Top