Prev: Count of Unique Values in Access Field
Next: How to populate a column in a row based on a value in another colu
From: 116 on 10 Mar 2010 17:12
Thanks for the assist. Its actually number of lines in the query.

116

"ghetto_banjo" wrote:

> if you just need a count of total number of records, you can use the
> DCount function:
>
> i.e.
>
> DCount("*", "tablename")
>
> or see this link for more info on the syntax:
> http://www.techonthenet.com/access/functions/domain/dcount.php
>
>
> One of many reasons you want to avoid assigning line numbers to
> records is if you delete a record in the middle, none of the other
> line numbers will update.
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Count of Unique Values in Access Field
Next: How to populate a column in a row based on a value in another colu