Query (Access2003)

[dubbs11]

I am trying to run a query to search through a table looking at a field, and return values that have "05" as the first two digits and "9999" or "9998" as the last four digits. Can anyone help me design this query.

Thanks,
Nick

[Aheron]

Give this a try

SELECT Table2.That, Left([That],2) AS Expr1, Right([That],4) AS Expr2
FROM Table2
WHERE (((Left([That],2))="05") AND ((Right([That],4))="9999" Or (Right([That],4))="9998"));

Table2 is the table and That is the field.


Good Luck