Adding four total fields to the switchboard ....

[Lance H]

Wondering if I can possibly get some help, please. I run a basic membership database for my car club which has about 680 members listed. On the switchboard, I would like to add four fields showing the number of life members, full (ordinary) members and associate members. The fourth being a total of the three. I request advice on how to show the totals. Just for general interest, the club's URL is: www.crcc.com.au

[madpiet]

use DCOUNT and filter by type.

[jojowhite]

as advised you can use DCount():
on design view of your form:

1. click on "Life" textbox.
on it's Property->Data->Control source, put
=DCount("1","tbl_company","Class = 'Life'")

2. on the other box, do the same, only
change 'Life' with appropriate Class ('Ordinary' or 'Associate')

3. for the total textbox:
=DCount("1","tbl_company","Class = 'Life' Or Class = 'Ordinary' Or Class ='Associate'")

[Welshgasman]

I would not do a DCount for the total , just add the three controls already populated?

[Micron]

@Lance H; next time consider combo boxes for single choices pertaining to one category. While you'll likely never add to choices like 'month' you might add reports and your way will require you to redesign the form. Much easier to have a table of reports and populate a combo and pick one. The only thing needing to be modified would be the code to cover the added report option.

[Lance H]

as advised you can use DCount():
on design view of your form:

1. click on "Life" textbox.
on it's Property->Data->Control source, put
=DCount("1","tbl_company","Class = 'Life'")

2. on the other box, do the same, only
change 'Life' with appropriate Class ('Ordinary' or 'Associate')

3. for the total textbox:
=DCount("1","tbl_company","Class = 'Life' Or Class = 'Ordinary' Or Class ='Associate'")

Thank you for your advice. It worked beautifully and is exactly as I wanted.

[Lance H]

Thank you for responding and for your recommendation.