Creating a query to display a weeks records

[shabbaranks]

Hi,

Im trying to create a query which will allow the user to print a weeks report. My current method prompts for between but that doesnt work as the user would have to put a day either side to get the desired result. What I was thinking was prompt for a begining date and then add on 5 which gets the working week?

Cheers

 

[student]

I'd start here and work forwards depending on exactly what you're trying to show:

http://office.microsoft.com/en-us/access-help/examples-of-query-criteria-HA010066611.aspx

If not then come back with clearer details of what dictates the required dates.

 

[shabbaranks]

I already looked through that before posting. The problem with that example is that its not a prompt it specifies the criteria. The "working week" which I am trying to find will always have a different starting value but I would always want the following 4 days (5 in total) from the point inwhich is entered.

Does that make sense?

 

[pr2-eugin]

Hello.. i think i have found what the problem is.. and it is working fine.. so what you need to do is..

Between #"&[Enter Start Date]&"# And #"&[Enter Start Date]&"#+5

Think the above would work..

 

[JANR]

Woulden a parameter query do the trick:

PARAMETERS StartDate DateTime;
SELECT *
FROM MyTable
WHERE MyDateField Between [StartDate] And [StartDate]+5;

JR