Claire has attended:
Excel VBA Intro Intermediate course
Queries and Grouping
I have a Job database, that lists all the different jobs (buildings) we have done. The Database has jobs recorded for 2007 and 2008. I have created a query that displays all the jobs for 07 and have a total at the bottom. The same for 08.
These jobs will mostly be duplicated for 08. I want to run a query/report that will group together the jobs but total them as well. so job1 07/08 grouped with total. then job2 07/08 grouped with total and so on. I can run the report that groups them by job but I cant get a total for each group.
any help you can provide would be appreciated
RE: Queries and Grouping
Hello Claire
Thank you for your posts.
We offer the forum service to all our delegates to answer questions related directly to content of courses they have attended with us.
While we are happy to support and advise our delegates in the manner that the forum was intended, there will be instances where we choose to advise delegates that we can only assist, or continue to assist, in a consultative role which would involve dedicated time from a trainer, and be billable.
This would apply to your question regarding your database. If you are interested in taking this option forward to resolve any remaining issues with your database, please contact our enquiries team to discuss your requirement on phone number.
Kind regards
Amanda
