Insert a Count Funcation into a Subform

[ecoed96]

I have built a database to track registrations for an event. This includes
class sign ups. I currently have to export the data to Excel to check the
class size using the “CountIf†Function.

I am looking for a similar function in Access or a set of commands that
would display the total of sign ups for a class in a subform that is part of
my input form.

 

[tina]

you can add an unbound textbox control to the subform's Footer section, and
set the ControlSource to

=Count([MyFieldName])

replace MyFieldName with the name of a field in the subform's RecordSource;
i usually use the primary key field, but it doesn't really matter.

hth

 

[Larry Linson]

If your database is reasonably well-designed, you can use a Totals Query to
Count the Records by Class, and display the results in a Subform Control.
If, on the other hand, you've "committed spreadsheet" and set the table up
like an Excel spreadsheet, it may not be so easy. If you would clarify the
data you have and how you have it arranged in tables, perhaps someone could
offer a more concrete suggestion.

Larry Linson
Microsoft Office Access MVP