I am working with a query in design view, my field looks like this:
Notepad: [Location] & "" & [Notes]
I have many locations but I only want a specific [location] to show in the [NOTEPAD] field if there happen to be [notes] in the field.
Tried using the expression builder - it seems self explanatory but I am new to this sooooo.
ex:
IIf (<<expr>>, <<truepart>>, <<falsepart>>)
Logically it seems easy but for some reason it isn't clicking.