I have a created a query 'Andy' using Table 'work' and Table 'ItemIndex'.
Common field 'Style' of both tables is inner joined.
Fields style and component are strings
Field in the query
a. Style from table 'work'
b. Component from the table 'ItemIndex'
c. Blank: IIf(Left([ItemIndex]![Component],3)="ZSK" Or Left([ItemIndex]![Component],3)="ZBL",[ItemIndex]![Component],'Unknown')
This gives me result I wanted.
Now if I create a query using the query 'Andy' and set the criteria for field 'Blank' as "Unknown", then it gives me an error "Data type mismatch in criteria expression".
How could I make this query running and what is the wrong thing I am doing?