Help with calender query

[stu1978]

Here's the setup I have (or the parts that matter)

My DB launches with a form called "HOME"
On this form is a date text box called "homedate"

My records are on a form called "CMSMAIN"
On this form is a date text box called "PROGRESSDATE"

What we do is select a date on the home page, then run a query which includes "PROGRESSDATE"
The criteria for this is "[Forms]![HOME]![homedate]"



This gives me a list of records where those 2 dates match. What I want to be able to do, is the same as above but instead of matching just that day, show all records for that week.

I'm sure there's an easy way of doing this, but i'm not finding it!

[CJ_London]

instruct you users to always enter a Monday or Sunday (depending on when your week starts) then use the following criteria

between [Forms]![HOME]![homedate] and [Forms]![HOME]![homedate] +7

alternatively look at using the weekday function to determine which day of the week has been entered and adjust the value accordingly

[CJ_London]

to use the weekday - and assuming you week starts Sunday the criteria would be

between [Forms]![HOME]![homedate]-weekday([Forms]![HOME]![homedate]) and [Forms]![HOME]![homedate]-weekday([Forms]![HOME]![homedate]) +7