How to Filter Subreport

[jmq]

I want to display the Highest and Lowest Prices in the left subreports

How to do that?

Please refer to attached file

Thanks!

 

[arnelgp]

wag table ang gamitin mo sa SubForm.
Un FrmPrice ang gamitin mo.
Copyahin mo un FrmPrice sa FrmPrice2.
i-rename mo Un frmPrice sa FrmPrice1.

i-Edit mo yun frmPrice1.
Sa Record Source:

SELECT * FROM tbl1Prices ORDER BY Switch([WholeSale]>[Retail],[WholeSale],[WholeSale]<[Retail],[Retail],True,[Retail]) DESC;

iso-sort nya un data mo sa Pinaka mataas
na presyo pababa.

i-Edit mo yun frmPrice2
Sa record Source:

SELECT * FROM tbl1Prices ORDER BY Switch([WholeSale]<[Retail],[WholeSale],[WholeSale]>[Retail],[Retail],True,[Retail]);

iso-sort nya un data mo sa Pinaka mababa
na presyo pataas.

 

[jmq]

eh tagalog ka nman pala eh. pinahirapan mo pa ako mag english!
Sige thank you kabayan!