What is going on?

[troy]

I put the follwoing expression in my Update to field:
IIf(Nz([dbo_tblProductversion].[Attachments],0)=-1,"Y","N")=[DEV_dbo_TblProduct].[Attachments].
I also have a ProductID field that is a number field from a seprate table.
When I add the following "<>[tblProduct].[productid]" in the criteria below
my Product table field. I get a mismatch datatype! When I dont add any
criteria to the product ID table I get the records I need. What is going on?
How does the product ID table interferrer with the ProductVersion table in my
query? I need this criteria so I can get the correct records. Any help would
be appreciated!

 

[[MVP] S.Clark]

Glad to see you solved the first error. Sorry to see that you're still
trying to use IIF(). I don't think that Attachments is a Yes/No field. I
also don't like the way you're trying to manipulate it to a text Y or N. I
think that I recommended that you use a lookup table, instead of the clunky
IIF. I don't understand how the productID is supposed to jive with this.

--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html