update query to make Stop adte date empty 1

[liliya13]

Hi,

I am trying to use update query in order to do Stopdt equal null when startdt=stopdt (both are date/time )

1. use update query option
2. put criteria into design view grid under startdt =stopdt
3.put is null ito update under stopdt

However I failed to do it ...
What I am doing wrong?

Thank you in advance

 

[PHV]

UPDATE yourTable SET stopdt=Null WHERE startdt=stopdt;

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

 

[liliya13]

I tried it but I got a message:

"operation must use an updateble query"

Does it mean that I should do table through make-table query first (as I used the result of select query)?

Or it is due to other error?

 

[PHV]

In my previous post, yourTable must be the name of a Table or an updatable saved Query.

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