I am converting an extensive Access 2000 database to SQL. Unfortunately, the original developer used "-1" / "0" as criteria in the queries insted of "Yes" / "No". Since SQL does not recognize -1 as a "Yes", I need to change every query that has a "-1" criteria to a "Yes" criteria instead.
Does anybody know if there is a simple way to do this short of manually opening each query and changing. Ideally I am looking for a search / replace type functionality or an simple VBA coding idea.
Ultimately I can run documenter on the queries, export to rtf, then do a search through there to identify queries that contain "=-1" in the SQL. Then go back to each identified query and manually change the dozen or so identified. This would take about 30 minutes to an hour -- so any proposed answer needs to be less work than this.