How to Count the Number of Records in a Continuous Form with Criteria in Microsoft Access

In this Microsoft Access tutorial, I'm going to teach you how to count the number of records in a continuous form and also apply criteria. For example, if you want to count the number of customers from Florida, you can obtain that count in the form footer using the Count function.

Daniel from Burbank, California (a Gold Member) asks: I'm trying to get a count of customers from my home state of California on my customer list. I've attempted several different formulas following your Form Footer Totals video, but I just can't seem to get it to work. For example, I've tried: =Count([State]="NY") and it doesn't work. Please help.

Silver members and up get access to an Extended Cut of this video. Members will learn how to create a combo box to select the state from a list of states that exist in the customer table. They can then filter the count results based on that state, allowing for on-the-fly changes. We will use one line of Visual Basic code.

MEMBERS-ONLY EXTENDED CUT VIDEO:

BECOME A MEMBER:

LEARN MORE:

PREREQUISITES:

LINKS:

RECOMMENDED COURSES:

USAGE:
=Sum([State]="NY")*-1
=Count(IIf([State]="NY",1,Null))

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, ms access count records in continuous form with criteria, Count Records in a Continuous Form, count function with criteria, count function

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[tomscroggin]

Thank you for ALL of your help! Each state has multiple orders. How would you count orders for each state individually and report for each on one report?

[Jojosmith]

Excellent all thumbs up. Thanks Richard

[azzaalajlan]

For some reason it gives me error instead of number of records matching the criteria. It only works when I write =Count(*). Any idea why is this happening?