Part No = calculations

[kabir_hussein]

Hi i was wondering is any way where you can add two fields up (chracters + numbers) to get a part No .

i have attached a screen shot of the table i am trying to do. many many thanks

kabir

 

[Mike375]

[Identifier] & "" & [PartNo]

That joins them like a single word

[Identifier] & " " & [PartNo]

That puts a space between them, like you would make one field from firstname and surname.

Mike

 

[kabir_hussein]

To Mike

many many thanks

worked a treat

kabir

 

[Mile-O]

[Identifier] & "" & [PartNo]

That joins them like a single word.

So does: [Identifier] & [PartNo]

No need for the Null String in the concatenation.