Querying specific weeks data within any given year?

[McArthurGDM]

I have a form set up to take in any date that the user can put in (eg 02/12/2007).

I would like to return any item in my database within that given week.

Anyone know how?



Thanks

[lfpm062010]

Using DatePart to get the week number. More on DatePart http://www.techonthenet.com/access/f...e/datepart.php

Then using DatePart to select that week number in the table.