creating macro to store calculated fields

[21041983]

Hi,

I would like to store some crucial caluculated fields in a table but since I've never used a macro it's just won't work. I ask to set a value in table and then when I create the expression it refuses to run.

It's a simple calculation that I would like to add in a table.

Thanks in advance

 

[21041983]

I just realized that my explanation mayne isn't very clear. When i create the macro to save the calculated field to a table i do the following:

Action= set value

Item= [Tables]![Order Details]![Total]

Expression= [Forms]![F_Order Details]![budget]*[Forms]![F_Order Details]![consumption]

But Access tells me he doesn't know Tables and when I type only [Order Details]![Total] it tells me it doesn't knwo the context of it.

All i want to do is let the user input the consumption and the budget, so that I can save the result to the table order details.

Any help would be really appreciated

Thanks in advance

 

[KenReay]

Hi

first, I should probably say, don't do this, it is seldom if ever a good idea to store calculated values

but if you insist, may I suggest you look up Update query in help,

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK