Autonumber field using just SQL in Access -- the datatype is COUNTER, as in:

CREATE TABLE contribSumRep
(
    pkId COUNTER,
...
)


Thank heavens again for usenet.