Hi All,

I have a field called ClassID that holds four numbers i.e. 1786

What I would like to do is break the numbers down into 4 seperate fields.

i.e.

field 1 (BuildingName) would hold whatever the first number is (in this case 1)

field 2 (EntranceNumber)would hold whatever the first number is (in this case 7)

field 3 (Floor)would hold whatever the first number is (in this case 8)

field 4 (RoomNumber)would hold whatever the first number is (in this case 6)

I will then use calculations for the results to show which building, which entrance, which floor and which room number.

I have already done the last bit.

I cannot figure out how to break up the 4 numbers.

Does ClassID have to be a number field or can it be a text field.

Thanks in advance

I cannot figure out how to break up the 4 numbers.

Use the Middle function such as:

Middle ( ClassId ; 1 ; 1 )

Middle ( ClassId ; 2 ; 1 )

I will then use calculations for the results to show which building, which entrance, which floor and which room number.

You should be using relationships to the respective tables instead.