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

On Mon, 13 Aug 2007 05:56:05 -0700, GregB <(E-Mail Removed)>
wrote:

>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]