How to open reports of records which meet a certain criteria?

[behnam]

Hi all,

I have a table called estimates and a field in that report is called RFA and this is a checkbox. How can i open a report i created (called EReport) for all rhe records in this table that have the RFA field checked (therefore true).

Thanks.

 

[pbaldy]

You can use this method:

http://www.baldyweb.com/wherecondition.htm

Or use a criteria in a query. Either way

RFA = True

 

[gblack]

The simplest way would be to create a query from your table that filtered all checked records... and then create and identical report that uses that query as the basis.

You could also create a new query with a parameter prompt, to prompt the user for a checked (or not checked) value, although with check boxes it gets a bit tricky if you want the option of showing Checked, not checked, or both checked and not checked.

Anyway... just a couple quick fix ideas, not the most elegant solutions, for sure...