AnsweredAssumed Answered

Add fields based on criteria of records

Question asked by user17753 on Apr 25, 2013
Latest reply on May 9, 2013 by user17753

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.

Outcomes