Find the total ammount of Records in a table and then show on chart

[HebieBug]

Am working on a database system and have got to the stage where we would like to see how big the database is getting.
We would like a graphical representation of how many records are in each table. Was attempting to make a form with a chart on it. Would like the chart to show how many records are in each table.
Anyone have any ideas?

 

[blakex1]

You would first need to build a query.
Take one field from each table you would like to count and pull it to the QBE pane in the query builder.
Next click on the "Summation" character in the toolbar at the top. This displays a new row in the QBE pane that lets you count the values that occur in that field. The default is "Group by" , you need to change this to "Count" for each of the fields.
Now run the query and you should get a result for the total number of records for each field (actually its a count for each table.

Now base your chart on these numbers and you are set.

 

[HebieBug]

It works but only on one table at a time if you try to have more then one table then it will give a responce of 0 across all of them
ANy other ideas that may help?