By Garry Robinson
Creating a numerical sequence for an Access query then appending that to a table (i.e. 1..2..3..4..5..6) in its own column is not as simple as it first seems.
Start with a table like this and the requirement is to compute a Counter field as shown in TestTableOutput.
TestTableOutput shows the computed column called Counter
Here is the answer,
DCount("id","TestTable","id <= " & [id]) AS Counter, Num1, date1, TestTable.id
Notes: If you use a filter in a query (instead of testTable), the exact same filter must be in the domain aggregate dcount equation.
Note: Look at qryNumericalSequence then
qryAppendCounters in download database
Other Pages at VB123.com That You May
Want To Visit
Other Pages at VB123.com That You May Want To Visit