Combing 2 fields

[Access_help_rob]

Hey how would i combine to fields to make it eg,
Purchase order is 1 field and line number is my second
so instead of haveing saying 12345 as order and
0003 as a line number my combined field would read 123450003
thanks
rob

 

[Mile-O]

NewField: [Field1] & [Field2]

 

[Access_help_rob]

cheers mile, i decided to just combine the fields together to make a unique number rather than messing around with cascading boxes but thanks for your time i appreciate it do u have msn?
rob

 

[Mile-O]

do u have msn?

Yes.

 

[Pat Hartman]

If you want line number to be fixed length and always have high-order zeros as place holders, you need to use the format() function.

fld1 & Format(fld2, "0000")