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.
> if you just need a count of total number of records, you can use the
> DCount function:
> DCount("*", "tablename")
> or see this link for more info on the syntax:
> 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.