Can an expression in a column be used to generate line numbers? 1, 2, 3, etc.

Thanks
David

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.

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.

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.
> .
> 

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.

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.
> .
>