You have probably read this before but it if wasteful and often problamatic
to store calculations in a table. It would be easy to get a query to give
you the value you need.
YourOption:=IIF([Total Cost]>350,[Total Cost]*.05,0)
Here's a link you should read:
Special characters that you must avoid when you work with Access databases
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.
Message posted via AccessMonster.com