If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
reports and queries
I did get the look i wanted, instead i (did what you told me) i made sure to
put the =count(*) in the header that way each colum/group would display it's total "Marshall Barton" wrote: That's good to hear, but what did you do to get the summary part? I just found out that was the problem and haven't had a chance to suggest ways to deal with it (I think a multi-column subreport might be the most appropriate approach). -- Marsh MVP [MS Access] tryn2learn wrote: I have read through our prior's and retried it is now working... thank you again for your help and support in this. "tryn2learn" wrote: you're right, this is how it currently looks: Status Open TechReq # Assigned To: Manager Requested: 123456789 P Port A Law TechReq # Assigned To: Manager Requested: 123456789 T Zach A Law Status Resolved TechReq # Assigned To: Manager Requested: 123456789 P Port A Law the report is partially grouped like i want. The "open" is together and the "resolved" is together with the information for each below it, but i don't know how to add the collective summary line where is shows how many are in each: Open 2 Resolved 1 |
|
Thread Tools | |
Display Modes | |
|
|