Please help with this scenario

[irfanparbatani]

Hi Admin

This is the scenario

I have this table

Route	Type	Road_Air	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG
125	Liquid	Road	12	12	12	12	12	12	12	12
125	Metal		13	13	13	13	13	13	13	13
125		Air	14	14	14	14	14	14	14	14

If My route no is 125 and Type is Liquid and Road_Air = Road, Display Jan Price
If my route no is 125 and Type is Metal, then display second priceline i.e Jan = 13
If my route is 125 and Road_Air = "Air", then display third priceline for Jan = 14
If my route is 125 and above all criteria doesn't meet, display 4th price for Jan.


Please help to code and get the price from the table.

[burrina]

What is Jan Price and where is it to be displayed?

[irfanparbatani]

What is Jan Price and where is it to be displayed?

Jan price is stated as starting from 12 dolars and with same route there are diff prices depending on the months

[NTC]

make a query using the normal query design view
it offers criteria rows - one each row put your criteria ... i.e.:

125 Liquid Road
125 Metal
125 - - - Air

side by side criteria is an AND statement while criteria on different rows is an OR statement.... I believe this will work fine unless I am misunderstanding your post....

[orange]

irfan,

It might be helpful to readers and to you if you would tell us more about your proposed database in plain English.
Once we know what you are trying to do, it will be easier to provide more specific responses.

Good luck.

[June7]

I think this topic has been abused enough https://www.accessforums.net/queries...ble-45623.html