Criteria for Deselection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I currently have a query set up to display clients should the tick box be
selected:
ie select = true

What criteria would I need to run a query to deselect these records?
ie select = false, just brings back a list of those who arent selected...
what i need is the query to deselect those that are already selected...

Thanks for any help.
 
Hi,
Something like this:

Update yourTable Set select = False Where select = True

Actually, all the above does is 'reset' the field so...
Update yourTable Set select = False
 
Im having a little trouble with it...

Is this correct? In the query design... under the 'Select' in the criteria
space I have entered Update Set Select=False Where Select=True... Is there
something I am missing?? Or is there something else I should enter as it
comes up with an error. Any help on this would be great.... thanks.
 
UPDATE Contacts SET Contacts.[Select] = False
WHERE Contacts.[Select]=True;

Would this be correct? Thanks...
 
Yes, that should be correct.

Did you try it? Did it work?
UPDATE Contacts SET Contacts.[Select] = False
WHERE Contacts.[Select]=True;

Would this be correct? Thanks...

Dan Artuso said:
Hi,
Something like this:

Update yourTable Set select = False Where select = True

Actually, all the above does is 'reset' the field so...
Update yourTable Set select = False
Click to expand...
Click to expand...
 
Hi,
The easiest way (when someone posts a SQL statement) is to go into
query design and then choose SQL View from the View menu.
Then simply copy the statement from the post and paste it into the designer.

You can then switch back to Design View if you wish.
 
yes this has now worked!! Thankyou very much.

John Spencer (MVP) said:
Yes, that should be correct.

Did you try it? Did it work?
UPDATE Contacts SET Contacts.[Select] = False
WHERE Contacts.[Select]=True;

Would this be correct? Thanks...

Dan Artuso said:
Hi,
Something like this:

Update yourTable Set select = False Where select = True

Actually, all the above does is 'reset' the field so...
Update yourTable Set select = False

--
HTH
Dan Artuso, Access MVP


I currently have a query set up to display clients should the tick box be
selected:
ie select = true

What criteria would I need to run a query to deselect these records?
ie select = false, just brings back a list of those who arent selected...
what i need is the query to deselect those that are already selected...

Thanks for any help.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top