[AccessD] Painted into a corner

John,

Using your example I have the following table where description would be the
'Generic Types' you have
such as..."CASES W/NO ERRORS FOUND ADC" or "DENIED/WITHDRAWN HR". The
'GenericTypes' appear multiple times in the table

The Table ("tblTypes"):
*ID, autonumber
Description, Text

Two queries are then done to get the two different types such as "CASES W/NO
ERRORS FOUND" or "ADC"

The Types queries:

qryTypes1...
SELECT Trim(Right([Description],3)) AS Type
FROM tblTypes;

qryTypes2...
SELECT Trim(Left([Description],Len([Description])-3)) AS Type
FROM tblTypes;