New Version 1.0 released October 27, 2002
FRC is a utility for previewing groupings and counts of
data in Access databases. You can quickly see the count of records in
tables and queries, either an overall count, or counts
for up to three field grouping levels. It can work with most fields in
all of your linked tables, whether they are Access, SQL Server, Oracle,
or other types of linked or ODBC tables. Just import one form into your
Access 97/2000/XP application and its ready to use.
(FRC requires a reference to Microsoft DAO 3.6. See the "more details" file)
New in version 1.0 is the option of selecting queries as a data source in addition to tables.
More Details - Download 97/2000/XP zipped (33k)
The main form for FRC is shown below. You select either a table or a query in the upper left, then select up to 3 fields to create a grouped recordcount query. You can also specify the sort order of the results, and a custom query name if needed. In this example, it shows tables from the sample Northwind database included with Access, and the field lists show the fields in the Products table.
Below is a sample query result for the above selection - created by clicking the "Fast Record Count" button. It shows unique record counts from the Products table, grouped by CategoryID and then SupplierID.
