Week starting with the date ######

[michaelmorris]

Ok,

I am making a database which has a set of lessons which have been booked for a particular date.

What I want to do is be able to have a pop-up box ask you for a date for the start of the week. e.g. I want to find lessons from the week starting 02/03/2007 for 1 week (e.g. 2nd - 9th), so I type in the box "02/03/2007" and it comes up with records from that week.

I have tried this in the criteria box:
[Enter date]+7
and
=Date([Enter Date])+7

But nothing works. Also, I decided to add a record with todays date, and then use the criteria =Date(), but that didnt work either!!!!

Help would be greatly apprecated

Thanks
Michael

 

[Rich]

Don't surround the Date with quotes

 

[wazz]

- create a new unbound form with an unbound textbox for user date-input; this will be your popup. call the form something like, frmDateRequest and the textbox something like, txtDate.
- for your data-form or report, create a query for the record source that includes your date field. your date field's criteria:

Between [Forms]![frmDateRequest]![txtDate] And (([Forms]![frmDateRequest]![txtDate])+7)

- you might want to change that to +6.

 

[michaelmorris]

Rich, I used "" to show the inputed data, I didnt use them in the pop-up box,

Wazz, Thanks, I will try that tomorrow .... got alot of work to do atm..... I will let ya know how it goes