Select all checkboxes in a query

[tconcepcion]

I am very new to Access and have little to no knowledge on SQL.



I have a table that has about 30,000 names on it. The first ~10,000 need to have Column 1 checked, the second ~10,000 need to have Column 2 checked, the last ~10,000 need to have Column 3 checked.

Right now I have all 30,000 names but no check marks. I need help to "mass check" the first group in Column 1 (and subsequently the second and third group with their respective columns)

Currently, my SQL is simply -

SELECT Table1.[First Name], Table1.[Last Name], Table1.Vinci, Table1.ID
FROM Table1;

Note: Vinci = Column 1


I hope this makes sense,
Thanks in advance

[June7]

Need criteria to filter records. Maybe you can use the ID field for that.

Why is there 3 fields if only one can be checked for each record? Should be 1 field with 3 options.

[tconcepcion]

Sorry, some records can have all three fields checked. Not many of them have this, so I can do these specific examples manually.

I was thinking about using the ID field, something along the lines of "ID 1-10567 = TRUE", but I'm not sure what the SQL would look like for that...

[June7]

User query builder to help get correct syntax, should be like:

UPDATE tablename SET fieldname = True WHERE ID BETWEEN 1 AND 10567

[tconcepcion]

Thank you! That is what I'm looking for,

However, I am getting the following error message: Syntax Error in FROM clause

My entire SQL looks like this:

SELECT Table1.[First Name], Table1.[Last Name], Table1.Vinci1, Table1.ID
FROM Table1
UPDATE Table1 SET Vinci1 = True WHERE ID BETWEEN 2 AND 17299;

I'm aware thats it's probably a parentheses issue, but I'm lost as to how to fix it.

[June7]

Why do you have the SELECT? My example shows only UPDATE action statement.

[tconcepcion]

Ok, I did this and now the query only shows the Vinci1 column, with none of the boxes checked.

[June7]

Did you Run the query?

[tconcepcion]

Obviously I'm very new at Access... Yes! That worked! Thank you so much!