Link to home
Start Free TrialLog in
Avatar of Gordon Hughes
Gordon HughesFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Extracting Data from Access field

I would like to have a query which extracts data from the first space,

IE
TTPK11163580000 TB19 JAW SYSTEM DAMPER
Extracting TB19 JAW SYSTEM DAMPER, which is text after the first space
The data exists in a field called [Old Description]

I guess it is a variation on
Mid([Old Description],InStrRev([Old Description],"#")+2)


Gordon
ASKER CERTIFIED SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Gordon Hughes

ASKER

Excellent response as normal