Thank you in advance for help given,
I am trying to run an append query - I need to be able to update the items to another table based on weather a field contains the information to match that field.
Problem: There are multiple rows of data with True/ False combinations, in others words just because it is true for one does not mean it false for all others.
Code:
IIf([Forms]![MainForm]![Field]="Name",True,"")
This works if it is true only. I am sure the "" needs to be something else just can not figure out. I want it to have no criteria if the IIF statement is false.
I have tried Like "*" and "*"
BTW - It can't be False because the item might be true for other columns.