filtering data on report by date?

  • Thread starter Thread starter karim
  • Start date Start date
K

karim

Hi everyone, I have 2 questions.
1) how can I filter data on a report by date. The info. is coming from a qry
and the qry is filtered "Des" under the date field, but it comes on the
report not sorted.

2) If I have a check box field, I would like on the bottom of the form in a
text box to tell me how many of these check boxes are checked and in a
different text box to tell me how many are not checked.

Is there any way to do these 2 tasks?
Thanks for all your help.
 
1. Set the Sort Order on the report.
2. I beleive you could use either the Sum or Count function.
Try:
=Count([Checkboxfieldname])
=Sum([Checkboxfieldname])
 
Thank you very much... Works great.

KenSheridan via AccessMonster.com said:
1. You are referring to the report's sort order here rather than filtering
it. A report will usually ignore the sort order of a query its based on; not
always, but you can't rely on it. Instead you should sort the report by
means of its sorting and grouping dialogue in report design view (its in the
View menu in my version of access, but may differ in yours).

2. For the True values (checked) use the following as the ControlSource of
the text box:

=Sum(IIf([YourFieldName],1,0))

and for the False values (not checked)

=Sum(IIf([YourFieldName],0,1))

Ken Sheridan
Stafford, England
Hi everyone, I have 2 questions.
1) how can I filter data on a report by date. The info. is coming from a qry
and the qry is filtered "Des" under the date field, but it comes on the
report not sorted.

2) If I have a check box field, I would like on the bottom of the form in a
text box to tell me how many of these check boxes are checked and in a
different text box to tell me how many are not checked.

Is there any way to do these 2 tasks?
Thanks for all your help.
Click to expand...
Click to expand...
 
Back
Top