Generate Sequential ID

C

Chrischik

Hi all - I've been trawling through similar questions but without really
finding what I'm looking for.
(I know that I'm committing the cardinal sin of trying to do something
without knowing enough basics but.....)
I have a column in my Table FindingID. (It was set to AutoNumber -but
actually I want it to be the following F (finding) yy (year) Number
(sequentially following from the previous one).
Can anyone help? Or at least kick me in the right direction.
thank you in advance,
Chris
 
Top