difference of dates

[Guest]

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

 

[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.

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())

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

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

John W. Vinson [MVP]