Excel to Access - formula does not work...

  • Thread starter Thread starter f_disk
  • Start date Start date
F

f_disk

I have the following working formula in excel and it works but when
import the excel file into Access it does not work at all.
I am trying to put it in either a query or a table in Access.

B C D E F
MT20 120 X1542 0.2 24.00

The formula in "F" is =C2*E2 (the catagory is set to number with
decimals)
When I enter the number into "F" it just reflects what I typed in
 
You don't use formulas in an Access table. If you need a calculated value it
normally goes in a query, form or report not in the table itself. For example
if you set up a query based on your table you would include a calculated
field which was =[c]*[e]. This formual then works on every record in your
table.

HTH - Sheila
www.c-i-m-s.com
MS Office training, london
 
Back
Top