T
troy
I am trying to do an update query with the following..
In Field: Attachments: IIf([dbo_tblProductversion].[Attachments]=True,"Y","N")
Because I want to convert the -1 and 0 to Y or N in a text datatype
I want to update to: [Dev_dbo_tblProduct].[Attachments]
I am getting an invalid name when I try and run the query. This expression
works in an append query to the same table but not in the update query. Yes I
have also tried to select a table, put it in the criteria section etc but
nothing seems to work. Any ideas?
In Field: Attachments: IIf([dbo_tblProductversion].[Attachments]=True,"Y","N")
Because I want to convert the -1 and 0 to Y or N in a text datatype
I want to update to: [Dev_dbo_tblProduct].[Attachments]
I am getting an invalid name when I try and run the query. This expression
works in an append query to the same table but not in the update query. Yes I
have also tried to select a table, put it in the criteria section etc but
nothing seems to work. Any ideas?