PDA

Click to See Complete Forum and Search --> : Database Newbie

Emerican
Oct 30th, 2000, 12:38 PM
Anyone know how to retain the number of records in a table. Its the easiest question you'll have to answer.
My data control is just data1
nkad
Oct 30th, 2000, 12:46 PM
Are you asking how to find out the number of records in a table?
barrk
Oct 30th, 2000, 01:00 PM
data1.recordset.recordcount
nkad
Oct 30th, 2000, 01:03 PM
Or in SQL,

SELECT COUNT(*) FROM <table name> AS record_count