Hi, How can I get the number of records in a query result? Thanks, Keren
K Keren Kapach Aug 18, 2003 #1 Hi, How can I get the number of records in a query result? Thanks, Keren
V Van T. Dinh Aug 19, 2003 #2 Use the DCount() function. DCount("*", "YourQueryName") returns the number of "rows" returned by your Query. Alternatively, you can change your Query to a Totals Query. HTH Van T. Dinh MVP (Access)
Use the DCount() function. DCount("*", "YourQueryName") returns the number of "rows" returned by your Query. Alternatively, you can change your Query to a Totals Query. HTH Van T. Dinh MVP (Access)
