By Richard Rost 2 months ago
Count Records in a Continuous Form with Criteria
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.
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.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
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
Subscribe to Count Records
Get notifications when this page is updated