You could be creative i guess and do it this way:
1. Create a table called Numbers or something with an autonumber and a
field titled Blk
2. Write a query to append 10,000 rows or whatever amount you need by
appending the value Null to the field Blk(probably a couple hundred
extra depending on the size of your database)
3.Create a macro called macro1. In macro1, use the openquery value and
type in the name of your append query.
4.Create a macro called macro2. In macro2, use the 'runmacro' feature
and set the account to 10,000 or whatever the number was you wanted it
to append.
3.Then, in the report datasource, include the Numbers table and it's
autonumber.
4. In the report, make a text box with the control source as the
autonumber. Make sure that in the report datasource that the Numbers
table is not linked to any other table yet. This little text box will
be your line number.
Note: to ensure that you only get the amount of lines you need, now you
may link the autonumber in the Numbers table to the ID of the item
you're reporting on. The use the 'group by' function so you dont start
to get duplicate records. Still need help? write back here or email
me at charles guzman at gmail dot com.
Chuck
