Run a query to pull numerous records (1,500~) (1 Viewer)

I've a list of customer ID numbers (about 1,500) in an excel spreadsheet of customers who need to have their loyalty status changed from false to true. The loyalty status is a TRUE/FALSE check box.

Is there any way to run a query pulling a list of customer IDs where I can quickly change all of their statuses in one go, or is it simple a case of going through customer records one by one and manually switching them?

Cheers

You can't edit a linked spreadsheet from Access.
However if you import it to an Access table, it is easy to do this using an UPDATE query.

ridders said:

You can't edit a linked spreadsheet from Access.
However if you import it to an Access table, it is easy to do this using an UPDATE query.

Click to expand...

That was actually what I meant, how am I able to do that?

Thanks a million

Create a new query and add your table and the loyalty status field.
Now change the query to Update in the ribbon
In the Update To row, type True
In the criteria row, type False.
Run your query