I have an imported table that has 1 data field ('name') with the following records
American Stairs (AMS)
DoRay Furnishings (DRN)
In a query, I need to separate the 3 character designation out from between the parenthesis... how can I do that in a query please?
The parenthesis always start 1 space after the name, and the designation is always three characters long (i.e. AMS, CHW)