Tuesday, March 27, 2012

How to find out how many records in multiple tables in one query

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.

Click on picture to enlarge

No comments: