paricular query grouping item in access table
to be more clear on my post if you have other solution to a fasted query, ( actually i work with 3.400.879 records!)
See attached now...
The xls file contain the structure of mine two table access, is only for example.
table1 contain the field:
cod1 is agengy
cod2 is sub agency
code3 is the name of product
tot is the quantity of product
tabel2 contain the field (actually in my db access is completly blank):
the field agency+subagency (is the joint value from agengy&sub agengy)
the field 45,18,50,43... are the name of product
i need a query to return into table2 from table1 the quantity from each agengy and sub agengy for produtcs.
the first 2 line of tabòe is the finale result from only 100394 and 1001773
in effetct is a transposition of value from vertical from orizontal based two param, or not?
I hope with tath is easy cler...