Hi,
I would like some help on how to look at the 3rd and 4th digit of the string in a table by using a query criteria? Any help would be appreciated. Then update a field based on that number or delete the record.
41700401AAJ
EXE.
If =70 and Flag = Mail
Delete the record
second query is
41300401AAJ
EXE.
If =30 and Flag = Mail
Update PC to 30
Thanks,
Nick Clutter