Hi All,
I have a report that I need to create based on data that is entered in my database. I need to total mold counts by day, and then total for the week and give an average mold count per day (as in the Excel example). But then I need it sorted in columns by 4 different customers (CUSTID) and then everyone else in "Reg". I have tried this report multiple times, but I keep getting multiple days listed in the week for each column, not one date in column 1. I really hate doing this report manually in Excel when all the data is live in my program.
Any ideas would be helpful.
Heidi
I have a report that I need to create based on data that is entered in my database. I need to total mold counts by day, and then total for the week and give an average mold count per day (as in the Excel example). But then I need it sorted in columns by 4 different customers (CUSTID) and then everyone else in "Reg". I have tried this report multiple times, but I keep getting multiple days listed in the week for each column, not one date in column 1. I really hate doing this report manually in Excel when all the data is live in my program.
Any ideas would be helpful.
Heidi