Hi, I have a database where I need to
1. group items by group and date,
2. then calculate total.
I do this using 2 queries. Since I need to create 50 groups or so that means 100 queries.
I would be pleased if somebody showed me away to cut it in half or other method to do this.
How can do the same without using cascade queries? If it possible to use only 1 query that means I need 50 queries not 100
See attached db.
BTW report grouping does not work for me as I need "fixed" style report where every month or so you can see even groups with zero in them. I tried to use report groupings but they showed me only "active" records and groups that were not used within a month were now showed.
1. group items by group and date,
2. then calculate total.
I do this using 2 queries. Since I need to create 50 groups or so that means 100 queries.
I would be pleased if somebody showed me away to cut it in half or other method to do this.
How can do the same without using cascade queries? If it possible to use only 1 query that means I need 50 queries not 100
See attached db.
BTW report grouping does not work for me as I need "fixed" style report where every month or so you can see even groups with zero in them. I tried to use report groupings but they showed me only "active" records and groups that were not used within a month were now showed.