Total Hour by Cycle Period

[Supe]

I have a data entry form that tracks total hours by Cycle Period that looks
like below

Store Name
Store Info
Vendor Name

Cycle 1 Date Cycle 1 Hours Cycle 7 Date Cycle 7 Hours
Cycle 2 Date Cycle 2 Hours Cycle 8 Date Cycle 8 Hours
Cycle 3 Date Cycle 3 Hours Cycle 9 Date Cycle 9 Hours
Cycle 4 Date Cycle 4 Hours Cycle 10 Date Cycle 10 Hours
Cycle 5 Date Cycle 5 Hours Cycle 11 Date Cycle 11 Hours
Cycle 6 Date Cycle 6 Hours Cycle 12 Date Cycle 12 Hours


Have it set up where the store information is entered by selecting the store
# from a drop down list. The user manually enters the vendor, the Cycle Date
and the Cycle Hours. It is possible that the same store would have more than
one entry for the same vendor if they had one project the first half of the
year and another the second have so there would be two entries on the table
for this same store and vendor.

I want to create a report that would show the total hours for each Cycle
Date for any entry that has the same store # and vendor name. I tried
creating a field in the query where the string is the Store# and vendorname
combined and then using that as a footer and header in the report, but if
there is more than one entry in the table with that store# and vendor, it
only shows that last entry in the table on the report. Was going to use a
seperate header and footer on the report for each Cycle period, but there is
only 10 rows in the Sorting and Grouping table. Not sure what else to try.