T The Bey Registered User. Local time Today, 14:38 Joined Jun 21, 2011 Messages 84 Aug 5, 2011 #1 Quick question. How can I count the number of records in a query, on a form? Basically I've a query set up and I want to show, on a preform of the query, how many records are present Last edited: Aug 5, 2011
Quick question. How can I count the number of records in a query, on a form? Basically I've a query set up and I want to show, on a preform of the query, how many records are present
T The Bey Registered User. Local time Today, 14:38 Joined Jun 21, 2011 Messages 84 Aug 5, 2011 #2 By the way this is what I'm using on my form to check for the records: =DCount("*","[qryNotActioned]","UniqueID='*'") I'm using the asterisk in the inverted commas because I want the count of any record with data in this field
By the way this is what I'm using on my form to check for the records: =DCount("*","[qryNotActioned]","UniqueID='*'") I'm using the asterisk in the inverted commas because I want the count of any record with data in this field
