G
Guest
Hello:
I have a table with among others fields, a date-time field and a volume
field consisting multiple volume entries. I need to sum up the volumes by the
hours.
For example, there may be a sum volume of 5000 between 16:00 to 16:59 hr
after totaling the different entries.
At the end of the day, I will have another table or query with 24 records
for the 24 hours.
Would anyone be able to assist with ideas or codes? Thanks. Best Regards.
I have a table with among others fields, a date-time field and a volume
field consisting multiple volume entries. I need to sum up the volumes by the
hours.
For example, there may be a sum volume of 5000 between 16:00 to 16:59 hr
after totaling the different entries.
At the end of the day, I will have another table or query with 24 records
for the 24 hours.
Would anyone be able to assist with ideas or codes? Thanks. Best Regards.