Web Development

General discussion

Gravatar
0 Votes
Locked

MS Access 2000 Report Totals

By MRA2 ·
My report looks great and has a count of the total records at the end.

However, I have a field with a check box, called CHECKED. At the end of the report I would like a count of how many records have CHECKED with a check in the box and how many records have CHECKED as blank.

Does anyone know how to accomplish this in MS Access 2000?

Thanks!
Alan
ABRAMOWITZA@coned.com

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

gravatar
Collapse -

by john_wills In reply to MS Access 2000 Report To ...

use the count function

gravatar
Collapse -

by MRA2 In reply to

count does not accept a condition. The Dcount function does.... Thanks

gravatar
Collapse -

by LukCAD In reply to MS Access 2000 Report To ...

Hi Friend! I have wrote so much that examples so you can use one of them:
For example the name of table is guestbook in our example for counting checked and unchecked records (name of field for checking = CHECKED) will next:

SELECT guestbook.Checked, Count(guestbook.Checked) AS [Count-Checked]
FROM guestbook
GROUP BY guestbook.checked;

Try it. It is real example that will go run.
Sincerely, LukCAD / Lukyanau Mikhail/

gravatar
Collapse -

by LukCAD In reply to

Don't forget that you can use it code for making request in your db and also you can use it in your programm code.

gravatar
Collapse -

by LukCAD In reply to

If you have questions write to me on my email: mikhail_lukyanau@msn.com
Sincerely, LukCAD

gravatar
Collapse -

by LukCAD In reply to

I afraid about your not understanding! PLEASE, write me and I will send to you ready database for example with your aim. I tried to do it with your email but I have received mail-daemon warning that your address is absent. Are you real need help?

gravatar
Collapse -

by LukCAD In reply to

I afraid about your not understanding! PLEASE, write me and I will send to you ready database for example with your aim. I tried to do it with your email but I have received mail-daemon warning that your address is absent. Do you real need help?

gravatar
Collapse -

by MRA2 In reply to

Poster rated this answer.

gravatar
Collapse -

by MRA2 In reply to MS Access 2000 Report To ...

I am using a form. It allows me to check off station 1 or station 2 or station 3. In the report, I change the filter to equal station 1 or station2 or station3. I know the answer uses the DCOUNT function but how?

gravatar
Collapse -

by MRA2 In reply to MS Access 2000 Report To ...

This question was closed by the author

Back to Web Development Forum

Start or search

Related Discussions

Related Forums