Whole week

[1234adam]

xxx
xxx


I do not know how to go about this, hopefully some one can help. When opening up the form I would like to see the whole weeks worth of data. Sunday's through Saturday. What i would want it to do is when you pick the thursday date there would be seven different records shown. One for sunday, one for monday, one for tuesday, and so on. And after updating the form it would update the entire weeks worth of data.

Help anyone?

 

[Mile-O]

I do not know how to go about this, hopefully some one can help. When opening up the form I would like to see the whole weeks worth of data. Sunday's through Saturday. What i would want it to do is when you pick the thursday date there would be seven different records shown. One for sunday, one for monday, one for tuesday, and so on.

Look in the Sample Databases forum for the Useful Date Functions

 

[1234adam]

I don't need to calculate a date. Maybe this will help.

Date: 1-6-04
Field 1--------- Field 2
Date----------- Number Served
1-1-04-------- 12
1-2-04-------- 9
1-3-04-------- 13
1-4-04-------- 15
1-5-04-------- 8
1-6-04-------- 10
1-7-04 -------- 1

This is what I want my form to look like. Lets say if I pick the 6th then i want all of that weeks info to show up. I want the Number Served to be linked to it's date