D
Doctor
I am trying to update all ChurchActiveCharter to NO and all
ChurchCurrentCharter to YES where ChurchActiveCharter is already YES. But as
far as I can tell, it is not updating the records in datasheet view
everything is left as it was before the update query is run.
Here is the code I have now:
UPDATE Church SET Church.ChurchActiveCharter = 0,
Church.ChurchCurrentCharter = - 1
WHERE ((([ChurchActiveCharter]+[ChurchCurrentCharter])<>0));
Any help would be greatly appreciated
ChurchCurrentCharter to YES where ChurchActiveCharter is already YES. But as
far as I can tell, it is not updating the records in datasheet view
everything is left as it was before the update query is run.
Here is the code I have now:
UPDATE Church SET Church.ChurchActiveCharter = 0,
Church.ChurchCurrentCharter = - 1
WHERE ((([ChurchActiveCharter]+[ChurchCurrentCharter])<>0));
Any help would be greatly appreciated