Update/Append Queries

daherb

Registered User.
Local time
Today, 18:47
Joined
Sep 14, 2005
Messages
66
Just wondering if someone can point me in the right direction so that i can solve my problem?

Basically what i have is a select query that carries out some calculations based on data entered. These calculations are expressions as i am sure you guys know. what i want to do is put the value from the expression/calculation into my table in the correct fields made for these values. However i have tried everything i can think of to get this data into the tables fields but to no avail.

example. Expr1: [field1]*[field2] the answer created by [Expr1] is the value i want to be placed in [field3]

Can anyone help me on how i can do this
 
Hum...

I would recommend you not store the value, but rather calculate the it whenever you need it.
 
Problem is that i need the values stored in order to generate much needed reports.
 
not to worry managed to sort something out that allows me to get the information into a report, resulting in having to have a very very large select query. LOL
 

Users who are viewing this thread

Back
Top Bottom