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 12:34
Can an expression in a column be used to generate line numbers? 1, 2, 3, etc.

Thanks
David
From: ghetto_banjo on 10 Mar 2010 13:51
Gotta ask, why do you want them? There are often questions on this
forum where people are trying to use a database like an excel
spreadsheet, and they are very different things.
From: ghetto_banjo on 10 Mar 2010 13:51
Gotta ask, why do you want them? There are often questions on this
forum where people are trying to use a database like an excel
spreadsheet, and they are very different things.
From: 116 on 10 Mar 2010 15:33
Just a quick way of getting number of lines with out creating a report. For
this project, really don't need a report.

David

"ghetto_banjo" wrote:

> Gotta ask, why do you want them? There are often questions on this
> forum where people are trying to use a database like an excel
> spreadsheet, and they are very different things.
> .
>
From: ghetto_banjo on 10 Mar 2010 16:13
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.
 |  Next  |  Last
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