creating a function that counts records and use that function in a query (1 Viewer)

icemonster

Registered User
Joined
Jan 30, 2010
Messages
502
so basically i need help making a function that will help me count the number of records from another table/query based on a field from the current query. can you guys show me a sample or point me to the right direction?

thank you.
 

[email protected]

Registered User
Joined
Jun 19, 2013
Messages
41
Have you had a look at the DCount function. This will count the records of a table based on the search criteria dCount("Field", "DBTablename", "Criteria Field A = ? and Field B = ? etc")
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom