How to write query

[shevada123]

Hello, I need help writing a formula in a query

I have a database where I need to be able to pull different prices according to type.

For example, if it is a SH then I will need it to pull a certain price of an item under the SH level

if it is a DD, then I will need to pull a price of the item under the DD level

How can I write this formula in my query as an expression or do I need to write it as SQL dlookup.

If it is the dlookup, how do I write that.

Help!!!

 

[Dona]

Hi,
you might want to check out this document
http://www.marshall.usc.edu/computing/PDF_Files/Access/AccessXP-Adv_Queries.pdf

Check out page 16.

Good luck!