I have a column in a query named PlacetEnd. This is populated from a table containing dates however in some instances the dates are not entered. I need to be able to use all the fields and where the dates are not entered I need the program to assign todays date to the fiels for the purposes of the query. I have tried this criteria IIf(IsNull([PlacetEnd]),Date(),Format([PlacetEnd],"mm/dd/yy"))
Unfortunately it only picks up the already filled in fields and not the blank ones.
Can anyone assist?