CONCATENATE

R

rjsrph

Hi, I have 3 fields that I need to merge into one. They are number fields.
each field will hold different numbers so I need preceeding numbers to
transfer over as well. The new field I will create will need to hold 11
didgets.

ie,
field 1: 00002
field 2: 0002
field 3: 01

How can I get these into one field as an 11 didget number
 
W

Wayne Morgan

Do you need them as one field or do you just want to be able to display them
that way sometimes?

Possible example:
Format([Field1], "00000") & Format([Field2], "0000") & Format([Field3],
"00")
 
R

rjsrph

Mr MVP.

Thanks for the suggestion, but I could not get it work. I was kept on
getting an invaild string error. I took out the comma and the quotes with
the zeros. That worked, but it took out the preceeding zeros so all that
should up using the example below was 221 and not 00002000201. can you
proivde a little more assistance.

thanks!

Wayne Morgan said:
Do you need them as one field or do you just want to be able to display them
that way sometimes?

Possible example:
Format([Field1], "00000") & Format([Field2], "0000") & Format([Field3],
"00")

--
Wayne Morgan
MS Access MVP


rjsrph said:
Hi, I have 3 fields that I need to merge into one. They are number
fields.
each field will hold different numbers so I need preceeding numbers to
transfer over as well. The new field I will create will need to hold 11
didgets.

ie,
field 1: 00002
field 2: 0002
field 3: 01

How can I get these into one field as an 11 didget number
Click to expand...
Click to expand...
 
R

rjsrph

Never mind the previous reply. I got it to work... Thanks!!!!

Wayne Morgan said:
Do you need them as one field or do you just want to be able to display them
that way sometimes?

Possible example:
Format([Field1], "00000") & Format([Field2], "0000") & Format([Field3],
"00")

--
Wayne Morgan
MS Access MVP


rjsrph said:
Hi, I have 3 fields that I need to merge into one. They are number
fields.
each field will hold different numbers so I need preceeding numbers to
transfer over as well. The new field I will create will need to hold 11
didgets.

ie,
field 1: 00002
field 2: 0002
field 3: 01

How can I get these into one field as an 11 didget number
Click to expand...
Click to expand...
 
Top