|Click on picture to enlarge|
Tuesday, March 27, 2012
In the picture, you can see how I gathered up the total numbers of rows from more than one table. Note how I use a "one" 1 in the DCount(1,"tableName") to refer to the first field in the query. This is easier than looking up the name of the first field.