I am trying to come up with a way to sum a field in a record set based on the following:
f_Date f_Time f_number
1/1/2013 01:00 100
1/1/2013 02:00 125
1/1/2013 03:00 75
1/1/2013 04:00 150
What I would like to do is to add the numbers in the f_number field based on the f_Time field. If the f_Time field is between 01:00 and 12:00 add the numbers in f_number field. If the f_Time field is between 01:00 and 17:00 add the numbers in the f_field then if the f_Time field is between 01:00 and 24:00 add the numbers in the f_field.
The records in the f_Time field are from 01:00 to 24:00 as in 24 hours in a day.
The date is duplicated in each record to facilitate someone exporting to Excel and be able to manulipate data better. I have set it up as a flat database but I am certianly open to setting it up differently.
Any help anyone could provide would be greatly appreciated as I seemed to be stumped.