Column for line numbers...

[116]

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

Thanks
David

 

[ghetto_banjo]

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.

 

[ghetto_banjo]

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.

 

[116]

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]

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.

 

[116]

Thanks for the assist. Its actually number of lines in the query.

116