I have a table with payment transactions I need to go through it and change any transaction that has a (what appears to be ) Blank transaction code to 1
The table field TransCode is a number data type it is also a lookup field to another table called TransactionTypes The lookup for Transactions.TransCode is
SELECT [Transaction Types].[TransTypeId], [Transaction Types].[TransCode], [Transaction Types].[TransTypeDesc] FROM [Transaction Types] ORDER BY [TransCode];
Back to my Transaction file, I want to check if TransCode is blank and another field - Particulars criteria is (InStr([Particulars],"DD Debtor Payment by "))
When I find a transaction that meets the criteria I want to update the TransCode to 1
I keep on getting 0 changes
Any help would be really apreciated
The table field TransCode is a number data type it is also a lookup field to another table called TransactionTypes The lookup for Transactions.TransCode is
SELECT [Transaction Types].[TransTypeId], [Transaction Types].[TransCode], [Transaction Types].[TransTypeDesc] FROM [Transaction Types] ORDER BY [TransCode];
Back to my Transaction file, I want to check if TransCode is blank and another field - Particulars criteria is (InStr([Particulars],"DD Debtor Payment by "))
When I find a transaction that meets the criteria I want to update the TransCode to 1
I keep on getting 0 changes
Any help would be really apreciated