Results 1 to 2 of 2

Thread: RecordCount

  1. Sep 29th, 2000, 06:18 PM #1
    jrgmrz
    jrgmrz is offline

    Thread Starter
    Junior Member
    Join Date
    Mar 2000
    Location
    Mexico
    Posts
    16

    Unhappy

    How do I store in a variable the total number of records in a table.

    Thanks.
    Reply With Quote Reply With Quote
  2. Sep 29th, 2000, 10:37 PM #2
    tomtan
    tomtan is offline
    Member
    Join Date
    Jul 2000
    Location
    Singapore
    Posts
    39
    Hi,

    There are several ways to Count the totol record in a table.

    Your can use the Recordset ".RecordCount" properties

    Example..

    CountRecord = RecordsetName.RecordCount

    OR

    You can use the SQL Select Statement "SELECT COUNT(*) AS TotalCount FROM Table1"

    Example..

    CountRecord = RecordsetName("TotalCount")

    [Edited by tomtan on 09-29-2000 at 11:39 PM]
    ThOmaS TaN
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width