M
Meredith9053
Only been working on access for a few months. so bare with me.
Basic Background: Working a Database to produce invoice for a small
jewellery company. Have customers and they are seperated into two lots,
agent and local pricing structure. So on each customer in the customers
table is account type which = either Agent or Local.
On my Orders table I have the customer name and address set up to
automatically come up once company name chosen. also the account Type comes
up with information.
In order details i have part number, description and price etc. when the
price comes up i would like to add this query in the Price box:
If Account type = agent, use Agent Price on products list, if account type =
Local use LocalPrice on products list.... make sense?
Second part of query, is that each customer has a discount percent off their
selected price lst. so will need to ad on the above query to reduce price by
the selected percent discount.
(foot note)
in the customers table under Discount I have just used data type number and
put in 12 or whatever, it is not formatted to a % . Is that necessary, or
should they all read the discount percent followed by % sign?
Thanks for your time. Sorry but this query is beyond me to work out! but
its one of the last things i need to do.
Basic Background: Working a Database to produce invoice for a small
jewellery company. Have customers and they are seperated into two lots,
agent and local pricing structure. So on each customer in the customers
table is account type which = either Agent or Local.
On my Orders table I have the customer name and address set up to
automatically come up once company name chosen. also the account Type comes
up with information.
In order details i have part number, description and price etc. when the
price comes up i would like to add this query in the Price box:
If Account type = agent, use Agent Price on products list, if account type =
Local use LocalPrice on products list.... make sense?
Second part of query, is that each customer has a discount percent off their
selected price lst. so will need to ad on the above query to reduce price by
the selected percent discount.
(foot note)
in the customers table under Discount I have just used data type number and
put in 12 or whatever, it is not formatted to a % . Is that necessary, or
should they all read the discount percent followed by % sign?
Thanks for your time. Sorry but this query is beyond me to work out! but
its one of the last things i need to do.