View Single Post
  #1 (permalink)  
Old Aug 16th, 2004, 04:27
Monie Monie is offline
Most Reputable Member
Join Date: Feb 2004
Location: Borneo
Age: 27
Posts: 1,608
Blog Entries: 2
Thanks: 0
Thanked 4 Times in 3 Posts
change auto number in access 2003

I am developing an asp reservation system.
Each user booking will be kept in a database which will have a unique booking ID!

currently i am using auto number as the booking ID,(increment number)
how to make my own "booking ID" inside the database access?
let say i want my booking ID looks like this...

FRS0001 until FRS9999

can anybody suggest another way if this cannot be done?
thanx!