Change query criteria value? (1 Viewer)

[Gunnerp245]

I have a database with 20 queries designed specifically for my department (SAM). A friend would like to use my database i.e. queries, reports, etc., but her department is named different (PAM).

The the field names in the each of our imported 'data' is the same, EXCEPT, each record in her department data field has "PAM" mine "SAM". However, her department is not part of my data import nor mine of hers nor will they ever be.

How can I, except manually, change every instance of "SAM" to "PAM" in the 20 queries?

Thanks
Gunner...

 

[Mile-O]

Rather than do this, create a combobox on a form with PAM and SAM as options. Then change PAM or SAM to [Forms]![YourFormName]![YourComboName] in your queries.

You can make this more user friendly with a good functional form.

 

[Gunnerp245]

Found a utility

Found a neat Find and Replace utility ADD-In that did what I wanted.
It is located at http://www3.telus.net/starthere/findandreplace/.
Gunner...

Edit: Initially entered the wrong URL.