Control Source in a Report

[tam]

I have a report in which I need to only display data of those locations which
are labeled as YES in my "OPEN" column field. I tried =YES and that converts
my NO flags to yes and I tried =IIf([OPEN]<>"NO",Null,"") but I receive an
error message. I only want the records with a YES to pull into the report.

 

[Larry Linson]

I have a report in which I need to only display data of those locations
which
are labeled as YES in my "OPEN" column field. I tried =YES and that
converts
my NO flags to yes and I tried =IIf([OPEN]<>"NO",Null,"") but I receive an
error message. I only want the records with a YES to pull into the
report.

It's not at all clear to me what you tried that "converts" anything.

Here's what you need to do... create a Query with all the Fields that you
want to display in the Controls of the Report. Put =True in the criteria
line under the OPEN column, assuming it is a Yes/No Field. Then specify that
Query as the RecordSource of the Report (click the upperleftmost little
square box, select Properties, click the Data tab, click the
downward-poiting arrow in the RecordSource property, and choose the Query
you just created and saved.

Just for the record, however, Open is a reserved word and not a good name
for a Field. I'm not sure it will cause a problem with this Report, but
using reserved words can result in confusion in some circumstances.

Larry Linson
Microsoft Access MVP