Here is the lesson on fishing first:
Create a simple select query, use the wizard it's fast and easy.
In this query, make sure that only the records you want to effect are returned. Once that is done, then convert to the update action query.
So for the fish:
The way your query is written:
BOTH fields [1CDF-E12-5 RAW] AND [MR-FUNCTION_Results] must = -2
OR
BOTH fields [1CDF-E12-5 RAW] AND [MR-FUNCTION_Results] must = -3
within the same record in order to be returned within the select query (or effected in the update)
However, it sounds as if you want
field [1CDF-E12-5 RAW] when it = -2 or -3
or when
field [MR-FUNCTION_Results] when it = -2 or -3
to be eventually
Then you need a query like this for the select:
- SELECT [MR-FUNCTION_Results].[1CDF-E12-5 RAW]
-
, [MR-FUNCTION_Results].[1CDFSEQS RG RAW]
-
FROM [MR-FUNCTION_Results]
-
WHERE ((([MR-FUNCTION_Results].[1CDF-E12-5 RAW])=-2))
-
OR ((([MR-FUNCTION_Results].[1CDF-E12-5 RAW])=-3))
-
OR ((([MR-FUNCTION_Results].[1CDFSEQS RG RAW])=-2))
-
OR ((([MR-FUNCTION_Results].[1CDFSEQS RG RAW])=-3));
This then converts to the update query:
- UPDATE [MR-FUNCTION_Results]
-
SET [MR-FUNCTION_Results].[1CDF-E12-5 RAW] = 0
-
, [MR-FUNCTION_Results].[1CDFSEQS RG RAW] = 0
-
WHERE ((([MR-FUNCTION_Results].[1CDF-E12-5 RAW])=-2))
-
OR ((([MR-FUNCTION_Results].[1CDF-E12-5 RAW])=-3))
-
OR ((([MR-FUNCTION_Results].[1CDFSEQS RG RAW])=-2))
-
OR ((([MR-FUNCTION_Results].[1CDFSEQS RG RAW])=-3));
(this SQL has been vetted in ACC2010)
Additionally I highly advise you to remove the dash/subtraction sign from your names "-" this is a reserved token and can cause you issues.
Access 2007 reserved words and symbols AllenBrowne- Problem names and reserved words in Access