Adding Prices in Access Database -
02-20-2004
, 01:57 PM
Calculations are new for me in Access.
I am working on a price guide. On the last form the user gets to,
they will see the base price for the item they selected. This is
shown in a text field called base price which gets inputed when
editing the record.
I need to have other options that they can select. Each of these
options has the price in a field also. (The options are in a table by
themselve)
Is it possible with access for the user to select what options they
need and the price is shown. Finally all of the options and their
prices should be in a list and added up with the base price to get the
final price.
Is this possible with access? If so, how should I set up the selected
options. |