default value

[Shane L.]

I want to be able to put in the default value of a field
the date 'mmddyy' then '-' then 'xx'(xx is a field from a
table). So it would look like this 103003-sl. Can
someone help me please. I hope I ask the question clearly.

Thanks

 

[Kelvin]

I don't know if you got your answer yet, but hope this helps.

A default is a value that is automatically entered for a new record. If you
already have something (in your case "sl") in a field then this is not a new
record and you can't set a default. You can update the field to what you
want. If your table is already populated with data and you want to perfrom
the update, create an update query and set the field you want to
CStr(Date())&"-"&[Field2]. This will convert the current date into a string
and concat the ending to it. Good luck,

Kelvin