Hello,
I have a query which gives me a list of tools currently due for calibration each month.
The query filters out tools which are not actively in use.
However, there is a subset of tools which even when not actively in use should still be shown as due for calibration.
I am no good with the sql for queries but hopefully I can explain from the design view screen well enough.
The field that determines if a tool should be on the list is called [toolIssued]. Generally, in the criteria section I have it set to show all tools due this month for whom the field [toolIssued] <>0. However, in order to include the specific subset of tools (called Dies) I have tried to use the following in the criteria section:
IIF(0, IIF([ToolDescription]= Like "*" & [Die] & "*") However, this returns an invalid syntax error. I have also tried:
IIF(= 0, IIF([ToolDescription]= Like "*" & [Die] & "*")
IIF(0, IIF([ToolDescription]= Like "*" & [Die] & "*",),)
However, both of those options also return invalid syntax errors.
Thank you for any and all assistance.