I'm using the following SET query which works perfectly
UPDATE [Data] SET [Action]="Query" WHERE [Acc Num]=230061;
But now I want to change it so it updates 4 fields in one go, tried the following but it doesn't
work, any ideas?
UPDATE [Data] SET [Action]="Query" AND [Comments]="test" AND [Promise Payments]="0.00" AND [Date]=date() WHERE [AccNum]=230061;