Count Records in a table

[armyofdux]

I have a switchboard form with an unbound textbox on it. I want to make a current statistics overview on this switchboard. I want the count function to count the number of records in a specific table.


For example I have the following table associated with the following fields.


"Student Data" is the table name
"Last Name" is one of the fields.

I just want a count of how many records are in that table. I keep running into errors when i try to use the expression builder.

[rpeare]

in the ON OPEN or ON LOAD event of the table, assuming the student count field is called fldStudentCount you could do this:

me.fldstudentcount = dcount("*", "tblStudentData")

if you want to count all records in tblStudentData (every record should have a last name so you shouldn't need to count last names)

if you do you can put criteria in the dcount function

me.fldstudentcount = dcount("*", "tblStudentData", "[StudentLastName] is not null")

I forget the syntax for null in domain functions but you get the idea.

[Missinglinq]

Actually, it appears that

"[StudentLastName] is not null"

and

"Not IsNull([StudentLastName])"

both work! Who knew?

Linq ;0)>

[armyofdux]

I dont have on load or on open in the text box I am trying to put this in.

[armyofdux]

in the ON OPEN or ON LOAD event of the table, assuming the student count field is called fldStudentCount you could do this:

me.fldstudentcount = dcount("*", "tblStudentData")

if you want to count all records in tblStudentData (every record should have a last name so you shouldn't need to count last names)

if you do you can put criteria in the dcount function

me.fldstudentcount = dcount("*", "tblStudentData", "[StudentLastName] is not null")

I forget the syntax for null in domain functions but you get the idea.

I think you meant in the ON LOAD of the form. I got it corrected. Also the syntax didn't want tbl included with it's name, just the name and it worked properly. Thanks for the help...love it when a good plan comes together.

[Missinglinq]

...the syntax didn't want tbl included with it's name, just the name...

Anytime you use sample code from here, or any forum, you have to substitute your own exact names.

Linq ;0)>

[armyofdux]

Is there a way to dcount a range of numbers?

[Missinglinq]

If you mean something like 'how many Records are there for Employees with 20 to 40 hours of accrued PTO time (in the example, a Field named APTOT) it would be:'

=DCount("*", "EmployeeTable", "APTOT Between 20 and 40")

once again substituting your actual names for EmployeeTable and APTOT.

Linq ;0)>