Can I get Access to auto fill an increasing value into a field starting from a number that I specify? (the field is also my primary key atm, but needn't be) I want to save myself typing the filename IMG_####.jpg as I enter data to cross index a bunch of photos for a household inventory sheet - posted the question in Yahoo answers
(here), but while i got a solution for Excel I think I'd rather use the Access db instead since its more flexible once the data is entered.