Code:
=Right(Date(),2) & Right(NZ(DMax("[EventNo]","[tbl_EmgCalls]","Left([EventNo],2)='" & Right(Date(),2) & "'"),"9900000")+1,5)-What this does is takes the last two digits of the current year (Right(Date(),2) ) and appends the last 5 digits of the largest number found for the year, plus one...