jsanders
If I Only had a Brain
- Local time
- Today, 19:26
- Joined
- Jun 2, 2005
- Messages
- 1,940
Sorry for this totally stupid question but my memory is just not what it once was.
I need to separate one field into two, in a table that was imported from excel
Basically it has a size and a unit in each field
Example:
24.67 sy
26.84 sf
Thanks in advance for jogging an old man's memory.
I want to do this in a query not code if possible I remember something about a formula you can enter into the update to box in a saved query.
I need to separate one field into two, in a table that was imported from excel
Basically it has a size and a unit in each field
Example:
24.67 sy
26.84 sf
Thanks in advance for jogging an old man's memory.
I want to do this in a query not code if possible I remember something about a formula you can enter into the update to box in a saved query.