Counting Unique Values in Report Footers

T

Tina Hudson

Good afternoon,

I realize there have been multiple posts on this issue, but I'm using MS
Access 2000 and even after I do exactly what Allen Browne (among others) have
indicated, I still get 1 as the value in the footer.

Here is what I have:

1. On the group header (Family_ID), I have a text box (txtTotalFamilies) =
1, running sum over all, format general number.

2. On the group footer (Family_ID), I have a text box (GrandTotalFamilies)
= [txttotalFamilies] with no running sum, format general number.

No sub reports.

Even though the group header shows a value of 1 for the first family and a
value of 2 for the second family, the group footer shows a value of 1.

Any help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top