Concatanation question

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

jonathan

Hi,
I am trying to concatate 3 fields into one field and removing slashes from a
date value.
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
 
Hi,
I am trying to concatate 3 fields into one field and removing slashes from a
date value.
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
Click to expand...
Jonathan,
Where does the "GSA" come from in your example?
Try this:
="GSA" & "/" & [JobID] & "/" & Format([DDate],"ddmmyyyy") & [UserName]
 
jonathan said:
I am trying to concatate 3 fields into one field and removing slashes from a
date value.
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.
Click to expand...


Is this the kind of thing you want?

"GSA/" & JobId & "/" & Format(DDate, "ddmmyyyy") & UserName
 
Back
Top