Update Query does not update

[yamy]

<code>
UPDATE UsersTable SET UsersTable.[Activated Date] = ([UsersTable]![Registered]+3)
WHERE (((UsersTable.[Account Activated])=&quot;yes&quot);
</code>

This query works fine in the test database

It will NOT work in the current version. I've checked and checked and checked again for a typo.

Without seeing the original and the current version, is it possible to speculate on what I might have changed in the tables or fields that might have affected this?
I have checked to see if fields are indexed, if field property values match, and I am hard pressed to see how a relationships change would affect this.

Happy to hear comments and ideas.
Thanks
Yamy

 

[Darrylles]

Hi,

Only thing that jumps out at me is the [Account Activated] = &quot;yes&quot; (in double quotes).

Not sure, but if you put true without the quotes, does it make a difference? Or is it a string field?

Regards,

Darrylle

&quot;Never argue with an idiot, he'll bring you down to his level - then beat you with experience.&quot; darrylles@totalise.co.uk

 

[Transcend]

I agree with Darrylles

what type of field is Account Activated?

Transcend

 

[yamy]

If, however, there is no data in the UsersTable.[Registered] field, there isn't a chance this query would work.

all better now

thanks

 

[Darrylles]

Hi Yamy,

If you don't supply such information - we have to assume that you have designed the table so that that field must never be null.

Yes - assuming isn't a good idea, but our only option under the circumstances (apart from umpteen posts to get a truly defined question).

Regards,

Darrylle &quot;Never argue with an idiot, he'll bring you down to his level - then beat you with experience.&quot; darrylles@totalise.co.uk