Excel to Access - formula does not work...
 

I have the following working formula in excel and it works but when I
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 2
decimals)
When I enter the number into "F" it just reflects what I typed in.


--
f_disk
------------------------------------------------------------------------
f_disk's Profile: http://www.excelforum.com/member.php...o&userid=36325
View this thread: http://www.excelforum.com/showthread...hreadid=562781

Excel to Access - formula does not work...
 

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

"f_disk" wrote:


I have the following working formula in excel and it works but when I
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 2
decimals)
When I enter the number into "F" it just reflects what I typed in.


--
f_disk
------------------------------------------------------------------------
f_disk's Profile: http://www.excelforum.com/member.php...o&userid=36325
View this thread: http://www.excelforum.com/showthread...hreadid=562781