unconcatenate from form into table?

S

slowly learning

I have a form where I want to be able to enter a concatenated value for
location into a field and then have the parts go into there respective
columns in a table.

The location is made up of locations within multiple buildings

C1AA32.4

If you imagine a grid layout "C1" would represent the building "AA" would
represent east-west grid in the building "32" would represent north-south
grid in the building and ".4" would designate one of four tiles at this grid
location

I want to be able to enter into a form as above but entries split into the
four different table columns

The fourth part tile location could be null

Can this be accomplished and if so how?
 
O

Ofer Cohen

There is no point in saving this valued into seperate columns in the table,
instead use a query to split this field into 4

In the query create 4 fields
building: Left([FieldName],2)
EastWest:Mid([FieldName],3,2)
NorthSouth: Mid([FieldName],5,2)
Tiles: Mid([FieldName],7,2)

In SQL it will look like

Select Left([FieldName],2) As building , Mid([FieldName],3,2) As EastWest ,
Mid([FieldName],5,2) As NorthSouth , Mid([FieldName],7,2) As Tiles From
TableName
 
I

i_takeuti

slowly learning said:
I have a form where I want to be able to enter a concatenated value for
location into a field and then have the parts go into there respective
columns in a table.

The location is made up of locations within multiple buildings

C1AA32.4

If you imagine a grid layout "C1" would represent the building "AA" would
represent east-west grid in the building "32" would represent north-south
grid in the building and ".4" would designate one of four tiles at this
grid
location

I want to be able to enter into a form as above but entries split into the
four different table columns

The fourth part tile location could be null

Can this be accomplished and if so how?
Click to expand...
 
Top