I am having trouble with my database. I have a query that has all of the values assigned to certain items in the database. However some items do not have a value assigned to them.
Currently when the query is run, items with no value assigned show as a blank. I would like to replace that blank with a value that I assign. How?
I have tried
in my criteria.That did not seem to do anything. My blanks were still there.
Currently when the query is run, items with no value assigned show as a blank. I would like to replace that blank with a value that I assign. How?
I have tried
Code:
IIF(IsNull ([Item value]), "180", [Item Value])