View Single Post
  #5 (permalink)  
Old September 19th, 2006, 06:22 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

It might be easier to keep the two parts seperate, and then only bring them together when you need them. Like:

tblYourTable
txtYear - default value: Left(DatePart("yyyy", Date()), 2)
intOrder - keep as increment

Then to display:

txtOrderNo: (Cstr([txtYear]) & "-" & CStr([intOrder]))

Anyway, keeps the processing down a little. Probably not much.



mmcdonal
Reply With Quote