Non updateable query

[Dave177]

It is this non-updateable query thing which I do not understandy why.

UPDATE tblApplicants INNER JOIN [qryWaiting for interview] ON tblApplicants.AppNo = [qryWaiting for interview].AppNo SET tblApplicants.[Date Chair Chased] = Date();

I would really appreciate it if somebody could tell me what was wrong with this.

Dave

 

[lespaul]

Why are you joining into the query? It looks like you have a date field in tblApplicants named Date Chair Closed and you are trying to fill that with today's date?

UPDATE tblApplicants SET [Date Chair closed] = Date();


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[PHV]

You may try something like this:
UPDATE tblApplicants
SET [Date Chair Chased] = Date()
WHERE AppNo IN (SELECT AppNo FROM [qryWaiting for interview])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Dave177]

PHV, Leslie,

Thanks alot! It now works.
So am I right in saying that you can't just make a query, change it from a select query to an update query, fill in the "Change to" bit and then run it..?

Dave

 

[PHV]

I don't know, as I never ever use the messy buggy query grid but the SQL view pane ...

 

[lespaul]

And I don't develop in Access at all...most of my help is SQL.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[Dave177]

Just when I thought I was beginning to manage...!
Thanks anyway.