By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,045 Members | 1,743 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,045 IT Pros & Developers. It's quick & easy.

problem updating a database with result from query

P: n/a
i have created a query that gives the sum of a table "results"....
i created the fields sums1, sums2....from that table results and i have put
the fields from another talbe (coupled with a field LEVID)
the fiels of that table i called sumtalberesults and i the query i put
them in and they are automatically set "grouped by" because the other fields
are set "sum"

now i want to put the results from the query in the field sumtalberesults

how can i do that???? if you understand what i mean

the relation between the first table en fable rresuts is one to more....


Reynaert Erik
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Not sure I understand, but why do you want to store a whole bunch of
calculated results? Processor speed is relatively cheap these days.
Just calculate as needed... and base your other queries on this
summary query.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.