report of table names and counts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to create a report that lists all tables in the database and
what the record could is for each table?

Thank you for your help.
 
Create a blank report and set its Record Source property to:
SELECT msysobjects.Name as TableName
FROM msysobjects
WHERE msysobjects.Name Not Like "msys*" AND msysobjects.Type=1;

Add two text boxes to your report's detail section with control sources of:
Control Source: [TableName]
and
Control Source: =DCount("*",[tableName])
 
Back
Top