Returning data from query depending on YES/NO field ?

  • Thread starter Thread starter TonyB
  • Start date Start date
T

TonyB

Hi,
I'm trying to create a report in Access 2000 which only includes the records
where a field called say RPRT is set to YES, and shouldn't include the
records if set to NO.
I'm not sure whether to do this in the query I use to collect the data for
the report, or if it is possible in the report to do this ?
I.e. should I limit the query to only return records with the field RPRT set
to YES, or return all records, and limit the report on onlly include the
records with RPRT set to YES ?
How would I do this in either case ?
Secondly I want to set RPRT to YES if a record is included in the report ?
Any ideas welcomed !
Tony
 
Hi,
I'm trying to create a report in Access 2000 which only includes the records
where a field called say RPRT is set to YES, and shouldn't include the
records if set to NO.
I'm not sure whether to do this in the query I use to collect the data for
the report, or if it is possible in the report to do this ?
I.e. should I limit the query to only return records with the field RPRT set
to YES, or return all records, and limit the report on onlly include the
records with RPRT set to YES ?
How would I do this in either case ?
Secondly I want to set RPRT to YES if a record is included in the report ?
Any ideas welcomed !
Tony
Click to expand...

If [rprt] is a Yes/No check box field, as criteria IN THE QUERY for
that field write:
-1

I'm afraid I don't understand your second question, unless you mean
.... if a record IS TO BE included in the report....
You, as user, place a check mark in the [Rprt] field and then the
query uses the Yes or No value to determine which records to return?
 
Back
Top