Update/Append Queries

[daherb]

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

 

[KenHigg]

Hum...

I would recommend you not store the value, but rather calculate the it whenever you need it.

 

[daherb]

Problem is that i need the values stored in order to generate much needed reports.

 

[daherb]

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

 

[KenHigg]

Cool... Glad you got it to work!