How to Filter Subreport (1 Viewer)

jmq

Registered User.
Local time
Today, 15:45
Joined
Oct 4, 2017
Messages
87
I want to display the Highest and Lowest Prices in the left subreports

How to do that?

Please refer to attached file

Thanks!
 

Attachments

  • Material Prices.accdb
    1.3 MB · Views: 76

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 06:45
Joined
May 7, 2009
Messages
19,169
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

Registered User.
Local time
Today, 15:45
Joined
Oct 4, 2017
Messages
87
eh tagalog ka nman pala eh. pinahirapan mo pa ako mag english! :)
Sige thank you kabayan!
 

Users who are viewing this thread

Top Bottom