whats the code to count all the records in field on a table in a databse like i want to count all Movie_titles that exist in a database
Printable View
whats the code to count all the records in field on a table in a databse like i want to count all Movie_titles that exist in a database
Code:NumberOfRecords = data1.recordset.recordcount
MsgBox NumberOfRecords
thanks found out the answer already by testing and tying