View Single Post
  #1  
Old December 8th, 2008, 11:35 PM posted to microsoft.public.access.forms
DBoyd
external usenet poster
 
Posts: 1
Default Incrementing journal voucher number

I creating a form that will need a field that will have a JV field that needs
to increment when a new record is created. The field is 12 characters long
with the last four digits incrementing, JV12TP09_ _ _ _. The JV and TP are
always the same the 12 is the current month and 09 is the calendar year. Can
anyone help me in creating such a number on a form. Thanks!! Using Access
2003.
--
Di~