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

[icemonster]

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.

 

[pbaldy]

How about this:

http://www.baldyweb.com/Function.htm

And

http://www.baldyweb.com/RecordCounts.htm

 

[gerry@docshop.ie]

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")