Seperating Data in a single field

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.
 
Using a table named Table1 with the following values:

SizeUnit
24.67 sy
26.84 sf

I created a query that returns the following results:

SELECT SizeUnit, Val([SizeUnit]) AS [Size], Mid([SizeUnit],InStr([SizeUnit]," ")+1) AS Unit
FROM Table1;

SizeUnit Size Unit
24.67 sy 24.67 sy
26.84 sf 26.84 sf
 

Users who are viewing this thread

Back
Top Bottom