Calculated Field Problem

D

DS

I have a field holding a price in an order details Table.
The Price comes from a menu that has 7 different price levels.
How do i get that field to grab the price level.
I tried a Query by putting Choose([PriceLevel],Price 1,Price 2, etc) in
the criteria part that didn't work. I also tried to make an expression,
tht didin't work either. Any help appreciated.
Thanks
DS
 
K

Klatuu

What do you mean by "menu". Hopefully, you don't really mean menu, This
should be a combo box. If it is not, then you need a Price table that would
probably be made up of:
ItemCode
PriceLevel
Price

In this table you would need the price for every price level of every item
in inventory. Make you combo based on a query on this table that will
include Price Level and Price. Make Price the bound column so it will update
your details table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get price in two ways? 8
Using restults from query to update specific field 2
Formula re value in column C or D, calculations made on either in column E? 8
aggregate calculation works in select query but not an update quer 4
Data Validation 1
Calculations based on varying number 0
Calculation in Access 1
Page numbering with Merged Document and IF statements 1

Top