Criteria for Deselection

[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.

 

[Dan Artuso]

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

 

[Guest]

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.

 

[Guest]

UPDATE Contacts SET Contacts.[Select] = False
WHERE Contacts.[Select]=True;

Would this be correct? Thanks...

 

[John Spencer (MVP)]

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...

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

 

[Dan Artuso]

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.

 

[Guest]

yes this has now worked!! Thankyou very much.

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...

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.

 

[PC Datasheet]

Use an Update query and set the Selected field to False.