Caluculations placing results in same row

[learning2fly]

Hi,




I have a table with various columns. I need access to do a calculation with data from two of these columns and then post it to the end of the row. The reasons for doing this are quite complicated but basically I am using the database with an ASP and it doesn't like calculations done to queries or with SQL so the result has to be stored as a column in the table.

ie

Multiplier | Multiplicand | Result
-----------------------------------
5 | 5 | 25

I know this would be really simple to do in Excel or something like that but I can't work out how to do it in access.

Thanks

Gordon

 

[scking]

By SQL or Action Query

UPDATE Table2 SET Table2.Result = [Table2].[Multiplier]*[Table2].[Multiplicand];

By ASP

Your design choices

Steve King

Professional growth follows a healthy professional curiosity