I am creating a report and am totally stuck on details not displaying how I would like. I cannot seem to figure this out, any help would be appreciated. I would like the report to display "days" each customer account has been serviced - by month. I've created queries to pull the "day" from each date serviced, and by month. I do have the days showing in the appropriate month column on the report, but I need for them to all start at the top of the detail line. Kinda hard to explain. But essentially my report is looking like this:
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ABC Company 02 04 12 05 10 15 20
I need the Acess report to look something like this:
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ABCCompany 05 02 10 04 15 12 20
Any help would be sincerely appreciated.