Getting Reports to show only certain data

[cr08rts]

Hi

I am needing a bit of help creating a report. I have a field in my table and form named 'Media permission given' with a drop down list to select either Yes or No.

I want to capture in report form who has not given media permission.

So i guess the question is how do i create the report to only show the list of people who have 'No' selected in the field? Currently i have a report that lists everyone in the database and a mixture of Yes's and No's.

Any feedback would be a real help

Thanks, Chris.

 

[vbaInet]

Welcome to the forum!

Create a query, select the table and all the fields you need from that table. Under the Criteria row for Media Permission Given put No.

Use this query as the Record Source of your report. Record Source of a property of the report.

 

[cr08rts]

Brilliant thanks!

I cannot believe how simple that was....and to think i couldn't find out how to do it for months. Spot on and much appreciated response.

 

[cr08rts]

One last quick thing if that's ok.

is it possible to get a total count at the bottom of the report?

 

[vbaInet]

Sure thing.

What version of Access are you using?

 

[DCrake]

In your report footer place a field there and set the control source to

=Count([[B]AnyFieldInDetailSection[/B]])

 

[cr08rts]

access 2010

 

[vbaInet]

In your report footer place a field there and set the control source to

=Count([[B]AnyFieldInDetailSection[/B]])

DCrake meant control (e.g. a textbox) and not field.

=Count(*) would be better. I was going to throw in a link from Office online regarding this for future reference which was why I asked what version of Access.

 

[vbaInet]

access 2010

Same advice from DCrake and myself, and here's a link:

http://office.microsoft.com/en-us/access-help/counting-in-reports-HA010120855.aspx?CTT=1

 

[cr08rts]

I have tried this in the footer but i keep getting #Error returned instead of a total.

 

[vbaInet]

What exactly did you put?

 

[cr08rts]

I tried both of the counts including (*) exactly as it was written then i tried counting the name of my field that's on the report.

=Count([First Name])

but i know i am missing something just not sure what, sorry if i seem i am being stupid but i have never used these formulas before.

 

[vbaInet]

That's what you get if you put it in the Page Footer. You need to put it on the Report Footer.

If you want a count per page then you need VBA code.

 

[cr08rts]

Thanks very much for your input,

I used the link you sent me all is totaled now.

 

[vbaInet]

Glad we could help!