Question Filter data and show it in a report (1 Viewer)

shamal

Registered User.

Local time

Yesterday, 16:34

Joined

Sep 28, 2013

Messages

77

• Sep 25, 2017

• #1

Hello Masters...

When the avarage is written, universities that accept this avarage appear..
How can you report only that?
thank you....

 

Attachments

• Universities.mdb

  984 KB · Views: 88

Ranman256

Well-known member

Local time

Yesterday, 19:34

Joined

Apr 9, 2015

Messages

4,339

• Sep 25, 2017

• #2

if you want to report on 1 university, youd open the report:

using ID numbers:
docmd.OpenReport "rpt",acViewPreview ,,"[id]=" & me.ID

for strings:
docmd.OpenReport "rpt",acViewPreview ,,"[University]='" & me.University & "'"

 

shamal

Registered User.

Local time

Yesterday, 16:34

Joined

Sep 28, 2013

Messages

77

• Sep 25, 2017

• #3

Ranman256
Can you apply the code to the attached example?
Because it did not work with me

 

shamal

Registered User.

Local time

Yesterday, 16:34

Joined

Sep 28, 2013

Messages

77

• Sep 27, 2017

• #4

Can you apply the code to the attached example?
Because it did not work with me

 

mike60smart

Registered User.

Local time

Today, 00:34

Joined

Aug 6, 2017

Messages

1,908

• Sep 28, 2017

• #5

Hi shamal

See the attached.

I recreated the Form.
Added a Combobox to allow the user to select the Average.
When you click the Command Button it Opens the filtered Report.

View attachment Universities.zip