Concatanation question

[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

 

[fredg]

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

Jonathan,
Where does the "GSA" come from in your example?
Try this:
="GSA" & "/" & [JobID] & "/" & Format([DDate],"ddmmyyyy") & [UserName]

 

[Marshall Barton]

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.

Is this the kind of thing you want?

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