Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-12-2017, 09:11 PM   #1
jmq
Newly Registered User
 
Join Date: Oct 2017
Posts: 87
Thanks: 24
Thanked 1 Time in 1 Post
jmq is on a distinguished road
How to Filter Subreport

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

How to do that?

Please refer to attached file

Thanks!
Attached Files
File Type: accdb Material Prices.accdb (1.28 MB, 33 views)

jmq is offline   Reply With Quote
Old 10-12-2017, 10:51 PM   #2
arnelgp
Newly Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 4,699
Thanks: 49
Thanked 1,566 Times in 1,492 Posts
arnelgp has a spectacular aura about arnelgp has a spectacular aura about arnelgp has a spectacular aura about
Re: How to Filter Subreport

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.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
jmq (10-12-2017)
Old 10-12-2017, 11:01 PM   #3
jmq
Newly Registered User
 
Join Date: Oct 2017
Posts: 87
Thanks: 24
Thanked 1 Time in 1 Post
jmq is on a distinguished road
Re: How to Filter Subreport

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

jmq is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Filter name of unbound subreport FTNSmyth11 Reports 4 09-22-2011 09:35 AM
filter subreport from form joepineapples Reports 4 01-27-2009 04:33 AM
Using a filter on a subreport suepowell Reports 2 04-12-2007 05:36 AM
Setting subreport filter to parent filter? Tekime Reports 0 08-13-2003 11:27 AM
[SOLVED] Applying filter to a subreport ValS Reports 0 11-20-2001 08:48 AM




All times are GMT -8. The time now is 05:19 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World