Hi Rich,
I did think about using an update query, i actually put one in place but then thought the following:
The data , once gone through this application needs to be exported back out and back into the main business system DB.
If i used the Update query to change all 1's to P's i will need...