sum query and related form control

[Guest]

I need help. (more ways than one)
I would appreciate someone answering/solving my problem but
you have to be patient.
First:
Subform looks like this in datasheet view.(based on tbl)
Date PT ST OT
10/5/04 25 25 25
10/6/04
10/7/04 25 25 25
10/8/04 15 30 40
10/9/04
The user wants to be able to enter a date in a text box
control which will then take that date (no matter if it is
in the future) and see the sum total of that date plus the
6 previous dates (which are all in sequence).
Ex: They plug in 10/10/04 the total should be 65 under PT.

This is where patience comes in. Be as thorough as you can
when explaining what I'm to do. How to create the query,
then what to do with it, and the control(s) on main form
and subform.

Thanks in advance.

 

[Guest]

before i begin, is the date in your table the Primary Key?

 

[Guest]

No, The PK is a PatientID: I managed to get my query to
give me the date range I was looking for, but not the
grand total. Since I had to use the Date field as part of
query it shows all records for that range. (understandable)
but now I have to get a grand total someplace!!!