concatation question

  • Thread starter Thread starter jonathan
  • Start date Start date
J

jonathan

Hi,
I have 3 fields on a form that am trying to concatate into one field on the
same form. This is to make a custom reference number that is given to the
customer.

my three fields are

Ctl Name Value Data Type
JobId 930 integer
DDate 27/01/2004 Datetime
UserName JW Text

This is the format i would like it to be in GSA/930/27012004JW.
If any one could point me in the right direction i would be very greatful.
Thanks in Advance
Jonathan
 
You don't need to store them in a field, rather just use a textbox to
display them.

Set the recordsource of the textbox on the form to...

="GSA/" & jobid & "/" & format(ddate,"ddmmyyyy") & username

I assume GSA is common to all records.

HTH
Sam
 
Back
Top