1
116
Can an expression in a column be used to generate line numbers? 1, 2, 3, etc.
Thanks
David
Thanks
David
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
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.
forum where people are trying to use a database like an excel
spreadsheet, and they are very different things.
G
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.
forum where people are trying to use a database like an excel
spreadsheet, and they are very different things.
1
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
this project, really don't need a report.
David
G
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.
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.
1
116
Thanks for the assist. Its actually number of lines in the query.
116
116