Formula in Query

  • Thread starter Thread starter Myke
  • Start date Start date
M

Myke

Hi All,

I'm trying to find a solution and I'm hoping that you can help. First
off, the formula is this:

Field A * 1.0925 = Field B

In a table there are about 14,500 numbers in Field A. I don't want to
overwrite the data in Field A but would like a query, macro, etc. to
calculate using the formula above and update Field B with the result.

Any help is greatly appreciated. I'd like to keep this in Access (not
Excel) if possible. Thanks.
 
If you reallly want to update [Field B] so that it contains 1.0925 times
[Field A], then:

1. In query design view, choose Update on Query menu.
This adds an Update row to the design grid.

2. In the Update row under Field B, enter:
[Field A] * 1.0925

3. Run the query.

In general, it would not be a good idea to store Field B in your table at
all. Instead it should be a calculated query field, so it is never wrong.
More info:
http://allenbrowne.com/casu-14.html
 
Back
Top