OTWarrior said:
is there a way of having an incremental number for each row of a query, like
an autonumber?
Well, you can do that, if the records an be sorted in a
unique (no ties) order, but, since the numbers will be
recalculated every time the query is run, what good are
they.
Given that you have a field that can be used for the unique
sort order, use a subquery in the calculated field:
IncNum: (SELECT Count(*) FROM thetable As X WHERE
X.sortfield <= thetable.sortfield)