Reports based on queries layers

[Mina Garas Daniel]

Hello everyone
I face a problem I don't know if there a solution to it or not

I have some reports based on layers of queries. I mean I create a query1 then creat query2 based on query1 then query3 based on query2 ....etc

Each query created based on item type in pervious query for more detail if item type in query1is wood, in query2 all data filtered by item type wood with some calculations if item type in query2 is metal, all data filtered by item type metal and copy in query3 with other calculations....etc

After that I creat reports based on those queries with same sequence using sub reports. I mean main report build on query1 then subreport2 based on query2 then subreport3 based on query3 ....etc

Every time I add new item type in last query I need to create next query and subreport that will base on it

My question is there any vba code or techniques make this process easier

Thanks in advance

 

[plog]

I'm kinda confused by your explanation, perhaps data would be a better way to demonstrate your issue.

With that said. my initial guess is by Grouping your data on the report. And of course whenever I hear someone with a request for simplification of complex data I fear they haven't set their tables up properly. Can you post a sample database?

 

[Mina Garas Daniel]

Thanks for your fast answer
The problem is file size 5 mb I will try to upload needed tables only.

 

[plog]

You can also zip it then upload