| Click on picture to enlarge |
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.
Subscribe to:
Post Comments (Atom)

No comments:
Post a Comment