Thanks Bill,
I felt that there were too many sub reports….and this is a push in the right direction…I'm gonna play and see what happens – but any advice is appreciated
So the group header can be specific to the project type?
And all this is run from 1 query? If so, I would just do a query based upon the FY – and only group by project type – with sub totals for that group and the unwanted project types would not be shown?
How do you set up the report form so that there is a header between each group? Any tricks with Access 2010?
Thanks,
B
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of wrmosca@comcast.net
Sent: Friday, January 10, 2014 1:13 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] RE: Final Step
Bryan
I wish I had more time to spend looking at your database so I could re-work your report, but maybe the "push in the right direction" would be to tell you not to use a bunch of sub reports. Instead put in a group header for the project type and remove your project type criteria from one query so it can be used for all types. The group header will separate out all Project 1 types into one section, project 2 into another section, etc.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
Microsoft Office Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My nothing-to-do-with-Access blog
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (8) |
Tidak ada komentar:
Posting Komentar