In my dbase I need to compare 4 pairs of values. If all pairs comply to my criteria in the update query the value "blnFilledIn" must be true else false. Let's say everything is according criteria, "blnFilledIn" is set true. Meanwhile a value changes and 1 or more pairs do not comply the criteria. I let the update query run but nothing changes. "blnFilledIn" fields don't change although some of the pairs don't meet up, "blnfilledin" should be false. In the example If you run the update query "blnfilledin" should be set true. Now change the next fields in the record : line 28 IdxTO = 20091130060101101 and line 31 bZone : true. Run Query again,nothing changes although some criteria are false. Clear all bFI, set all to false, run query again and you'll see line 28 and 31 are false. Now I want to do it in one update query. Is it possible to set or reset values in one run.
28.9 KB Views: 270