Forcing Numbers

[Dineedshelp]

I have four tables, location, department, Product and Asset. All these have unique ID numbers. I want to format the ID numbers on a form so that they appear as three numbers ie, for department 1, I want the number to appear as 001, same for the other tables.

I then want to take all four ID numbers from the above tables and combine them to make one longer number ie:

Location = 001
Department = 003
Supplier = 056
Asset = 199

Will make 001-003-056-199

How can I do this?

Please help!!!!

 

[Craig0201]

You concatenate using the & operator. Hence you need...

[Location] & "-" & [Department] & "-" etc....

Craig

 

[Parax]

Try this:

=format([Location],"000&quot & "-" & format([Department],"000&quot & "-" & Format([Supplier],"000&quot & "-" & Format([Asset],"000&quot

 

[Dineedshelp]

Parax

Love ya!!!! (Well not literally!!!)

Thank you!!!!

Di

 

[uclan]

i like this but where is the code attached tO?

Im verY slow on this sort of stuff!1

MAl

 

[Dineedshelp]

In the control source of the properties box, use the expression builder and add the code