Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to insert a "calculated field" of a query in a separate table

Status
Not open for further replies.

accessuserit

Programmer
Nov 10, 2001
29
IT
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!!!!!!!!!!!!!!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top