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
>
>