So I have 17 departments, and each need to be summed up grouped by a number (Z1 number) - a unqiue number which changes with each business day.
I eventually need a report to display all 17 departments, whether a sale has gone through or not.
I am trying this from a different angle, but I need to know how to increase the optimisation of eventually producing a report.
My first idea was to create 17 queries, and use VBA to generate the report based on those, but then I had another idea -using DSum, but I've read it's ineffective and slows down processing.
So I want your opinion - do I do a DSum for all my fields, or an overall query which will save the data into a table for easy access?
For example - I could use an update query to do the math and update the table and base my report on that, or I fill the report using VBA and DSum
Any ideas?
I eventually need a report to display all 17 departments, whether a sale has gone through or not.
I am trying this from a different angle, but I need to know how to increase the optimisation of eventually producing a report.
My first idea was to create 17 queries, and use VBA to generate the report based on those, but then I had another idea -using DSum, but I've read it's ineffective and slows down processing.
So I want your opinion - do I do a DSum for all my fields, or an overall query which will save the data into a table for easy access?
For example - I could use an update query to do the math and update the table and base my report on that, or I fill the report using VBA and DSum
Any ideas?