If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Column for line numbers...
Can an expression in a column be used to generate line numbers? 1, 2, 3, etc.
Thanks David |
#2
|
|||
|
|||
Column for line numbers...
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. |
#3
|
|||
|
|||
Column for line numbers...
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. |
#4
|
|||
|
|||
Column for line numbers...
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. . |
#5
|
|||
|
|||
Column for line numbers...
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/f...ain/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. |
#6
|
|||
|
|||
Column for line numbers...
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/f...ain/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. . |
Thread Tools | |
Display Modes | |
|
|