Issues with Update Query. Please Help!

[Guest]

I built and expression from a table field to convert the Y/N datatype (-1, 0)
to a Y or N. I did this because the target table is a Text datatype with Y or
N put in manually.

I need to update my expression field to a update query, and the update
query wont allow me to add the correct table from where I built the
expression. Because of this I can not do an update query. I have done and
used the exact query on a select and Append query but cant complete the
Update Qry. I get a syntax error only when I try to add the table to my
query. If I dont add the table it works fine!

Here is my expression and it WORKS FINE. PLEASE PROVIDE ANY OTHER
INFOMATION YOU MAY HAVE EXCEPT TO TRY "THIS TYPE OF EXPRESSION" I have tried
everything and more from other members ideas and nothing seems to work. I do
however want to thank everyone that is trying to help.

This is so easy I must be overlooking something? Please help it has been
to long time spent on this. I have posted here before but nothing seems to be
working. Please help! IIf(dbo_tblProductversion.Attachments=-1,"Y","N")

 

[Rick B]

Please do not post duplicates in more than one newsgroup. You have at least
one response in your other post.