accessuserit
Programmer
Help me to function to insert a "calculated field" of a query in a separate table.
I have this problem:
"query to complex"
This limite my operation. the solution arent to write the result of a "calculated field" in a field of another table for reuse this value more efficently.
I have a proget thet use about 360 field to avaluate a complex statistic.
The schema is:
media1 = (avrg [field1A]+[field1B]+[field1L])
media # = (36 group of field.....)
each field of "A" series (36 field) are now calculated to create a column result...
relative value = (([field1A]/ media1)+([field2A]/ media2) +([field3#]/ media#)) / [value x]
!!!!!!!!!!! is very complex !!!!!
this work now...
I need to make a graph will contain the result of each column (10)
If i try to load the static value, receive this message : Query too complex (is true....)
If i store the single column result in another field of another table, the problem is resolved.
Write me the code !!!!!!!!!!!!
Tanks
Paolo Chiesa - Milan, Italy
P.S. sorry but is the my first project!!!!!!!!!!!!!!!!
I have this problem:
"query to complex"
This limite my operation. the solution arent to write the result of a "calculated field" in a field of another table for reuse this value more efficently.
I have a proget thet use about 360 field to avaluate a complex statistic.
The schema is:
media1 = (avrg [field1A]+[field1B]+[field1L])
media # = (36 group of field.....)
each field of "A" series (36 field) are now calculated to create a column result...
relative value = (([field1A]/ media1)+([field2A]/ media2) +([field3#]/ media#)) / [value x]
!!!!!!!!!!! is very complex !!!!!
this work now...
I need to make a graph will contain the result of each column (10)
If i try to load the static value, receive this message : Query too complex (is true....)
If i store the single column result in another field of another table, the problem is resolved.
Write me the code !!!!!!!!!!!!
Tanks
Paolo Chiesa - Milan, Italy
P.S. sorry but is the my first project!!!!!!!!!!!!!!!!