Is there a method to get a total record count from multiple tables or queries? with VBS or SQL ?
B Barry Phillips Dec 9, 2004 #1 Is there a method to get a total record count from multiple tables or queries? with VBS or SQL ?
V Van T. Dinh Dec 9, 2004 #2 Not sure which way you want the "total record count from multiples tables or queries": adding record count from each table??? However, check Access Help on the DCount() function.
Not sure which way you want the "total record count from multiples tables or queries": adding record count from each table??? However, check Access Help on the DCount() function.
B Barry Phillips Dec 10, 2004 #3 Yes I am looking to sum the record count of several different queries to be exact.
V Van T. Dinh Dec 11, 2004 #4 You can write a short function using DCount() to count the number of returned rows from each Query and then sum them up. Alternatively, you can create a UNION (All) Query and use DCount() function on this Union Query. Check Access Help on DCount() function and Union Query.
You can write a short function using DCount() to count the number of returned rows from each Query and then sum them up. Alternatively, you can create a UNION (All) Query and use DCount() function on this Union Query. Check Access Help on DCount() function and Union Query.
