update query

  • Thread starter Robert Blackwell
  • Start date
R

Robert Blackwell

I need to run an an update statement like this on an existing dbase query. I
know this script would work but AFAIK access doesn't use plain sql
statements like these and everything is wysiwyg

UPDATE _qryInactiveCustomers SET StatusID='2' WHERE StatusID='1';

how do I go about doing this?
 
R

Robert Blackwell

I had already tried that and got this message.

"Operation must use an updateable query."
 
R

Robert Blackwell

Okay...how can I get around this? basically, the originally query is a list
of customers whos most recent order was before 12/31/2001.

I need to change all their statuses to inactive so they do not continue to
get mailings form us. Like you said, I can't even change it manually when I
run the query and see all the records, I can't edit anything.

Perhaps dumping a list of customer id's and then doin some type of query to
change all the status's of those id's to inactive? How would I even do this.
 
R

Robert Blackwell

Btw, I removed the status table and just used the constatus id field from
contact data table, and it's still uneditable.
 
R

Robert Blackwell

What I ended up doing, is copying the cells with the contact Id, copying
them to a new table, then running a new query to match existing contacts to
those ID's and then update the account of those ids to the appropriate
status. A little clumsy I guess but it worked.
 
Top