sorting reports

  • Thread starter Thread starter tom
  • Start date Start date
T

tom

hello,
does anyone know how i might be able to create a report
that does not report from every record? in other words; i
have a check box on my record form. i want to be able to
create a report that lists only information from the
checked records. leaving the unchecked records out of the
report.

thanks,
tom
 
Hi Tom,
I have a suggestion that might help you. I think you
should create a query that will only show records with a
Yes answer (which is also the checked records). In the
Query Design View, choose the attributes you wish to show
up on the report. Then under the attribute that contains
the check box, type =Yes in the criteria box. Run this
query and it should only give you information concerning
the records that have been checked. Using this query, you
can create a report that will give you the information you
wanted. Hope I was of some help to you.
Sincerely,
Darlene
 
hello,
does anyone know how i might be able to create a report
that does not report from every record? in other words; i
have a check box on my record form. i want to be able to
create a report that lists only information from the
checked records. leaving the unchecked records out of the
report.

thanks,
tom
Click to expand...

Is there a yes/no field in the Table bound to the checkbox? There
would need to be; a Form doesn't contain any data, it's just a window
to view data.

If there isn't such a field, add one. Then base the Report on a Query
using a criterion of

True

on this field.
 
thanks for the suggestion!
unfortunaly i'm just to new to access to get it to work.
when i type =Yes it changes to "Yes". then when running
the query the results are blank even though i have records
that are checked. access it's so easy to access.

tom
 
Back
Top