listing records in report by yes/no field

[puthenveetil]

Hi all,

I had a report which is based on a table with one yes/no check field.
Is there any way to list the records which is unchecked, I mean not selected.


Thanks

 

[Brianwarnock]

Type False in the criteria for the field in the recordsource query

 

[puthenveetil]

Hi bryan,

Can you please tell me how to do that


Thanks in advance

thanks

 

[Brianwarnock]

Ah! I've reread your first Post and it would appear that your report is based directly on the Table, it is better practice to base a report on a query, then you can easily select/filter data. If the report was based on a query the checkbox field could then have the criteria I suggested applied as per the jpg

 

[puthenveetil]

Thanks Brian,

If I am not disturbing you, can I ask one more thing? Can i use this query based on a certain value . I mean in that criteria filel can i use two fields, that is one by this yes/no field and by a specific value???


Thanks

 

[Brianwarnock]

You need to read access help on the use of criteria in queries , but essentially criteria in different fields on the same row are "AND" conditions in different levels for the same field are "OR" conditions.

Hope this helps

Brian

 

[Brianwarnock]

You need to read access help on the use of criteria in queries , but essentially criteria in different fields on the same row are "AND" conditions in different levels for the same field are "OR" conditions.

Hope this helps

Brian

 

[Brianwarnock]

You need to read ACCESS help on using criteria in queries, but basically entries on the same row for diffent fields are "AND" conditions and on different levels for the same field are "OR" conditions,
Hope this helps

Brian