Excel to Access - formula does not work...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

f_disk - 19 Jul 2006 11:43 GMT

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

Reply to this Message

Sheila D - 19 Jul 2006 12:08 GMT

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

> 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.
[quoted text clipped - 6 lines]
> decimals)
> When I enter the number into "F" it just reflects what I typed in.

Reply to this Message