Web Development

Ask something
Discussion Locked

MS Access 2000 Report Totals

0 helpful
10 replies

by mra2

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

10 replies

by mra2

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

by lukcad

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/

by lukcad

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.

by lukcad

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

by lukcad

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?

by lukcad

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?

by mra2

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?

This discussion is closed to new replies.