problem updating a database with result from query

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Foxster

    problem updating a database with result from query

    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....

    greetings

    --
    Reynaert Erik



  • Pieter Linden

    #2
    Re: problem updating a database with result from query

    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.

    Comment

    Working...