use expression in a query to return date base on fields - Microsoft Community

hello

 

i trying create expression in query add field called prepermitproj  using the dateadd , isnotnull function display date in field, if prepermitspec field has date, add 2 (date + 2) , display in prepermitproj; if prepermitspec null (meaning there no date), use prepermitactual field add 2 (date + 2) , display date in prepermitproj. not sure how proceed if value null , add 2 using different field.

that have far:

prepermitproj: dateadd("d",2,[prepermitspec])

thank suggestions may have.

sylvie

.

i'm not following logic can use nz() function replace null value value. instance

nz([datea], [dateb]) return datea if not null. if datea null dateb returned.

Office / Access / Windows other / Office 2010