Hi all,

Ok, I have a table in my DB that is populated from a word form that I have created. In the form I have 7 "Date" fields that are filled by a user and 7 "Hours" fields that are also filled by the user. I have the same 14 columns in my table that correspond to the fields in the form. Some other fields on the form/columns in the table are "Inspector", "Project Number", "Report Number", and so on.

I would like to generate a table or report, whichever is easiest, that will list the data by date instead of by report. When listed by report, I have to show all 7 days and hours for those days. Any help will be greatly appreciated. I can send the DB to whomever would like to help with it.