to get Max Value between 2 criteria (1 Viewer)

[NurulScare]

Hi, Someone please help me. I have one Table. I need to get Max Qty based on B/S field.

Ex: B/S

A - 200
A - 500

Max qty = 500.

Part No	B/S	Qty
1	A	200​
2	A	500​
3	B	1000​
4	B	300​
5	C	200​
6	C	350​

 

[arnelgp]

you need to Total Query:

select [B/S], Max([Qty]) As MaxOfQty From yourTable Group By [B/S];

 

[NurulScare]

you need to Total Query:

select [B/S], Max([Qty]) As MaxOfQty From yourTable Group By [B/S];

Thanksss