How to store calculated values

[Nitrous]

Hi there,

I have got my database to calculate a value if something is either enabled or disabled using the IIf command. Now what I want to do is store that value in my table in a field, how do I go about doing this?

Calculating Total Price so that it can be displayed on an invoice.

Many thanks...

 

[mousemat]

Calculated

Nitrous

The idea is not to store calculated values in a field. You calculate them when you need them be it on a form or a report.

Ian
If you want i have a small dbase app i could email you to show how it works

 

[Mile-O]

Nitrous

The idea is not to store calculated values in a field. You calculate them when you need them be it on a form or a report.

Ian
If you want i have a small dbase app i could email you to show how it works

Also (on the same topic) - http://www.access-programmers.co.uk/forums/showthread.php?t=62224

 

[Nitrous]

Also (on the same topic) - http://www.access-programmers.co.uk/forums/showthread.php?t=62224

I managed to fix that now

It calculates it all using an IIf command, quite cool, first time ive ever used one, works like a dream, cheers for the help!