Access 2010 - expression builder

[Haemdall]

good afternoon

I have worked with previous versiosn of access (2003...2005). Now i have to create a new DB with access 2010 and i´m stuck with a problem:

A need to make a calculated column. i used the expression builder because a thought that it was a good way to do it. but for some reason i can´t get the formula to work.

the objective is to automaticcaly show in the target column Yes or N...
if the Record number is not full (if there is a record number, then the process was accepted)...
if the today date is more the 30 days over the date of received Record, then it automaticaly goes to "N"

the program shows a windows with a expression: the expression cannot be used in a calculated column. but a have used a formula that i believe it should work:

IIf([Record number]<>" ","Y",IIf((Date()-[Record Date])>30,"N",""))


in other words...

if column "record number" not empty... "Y" ( in the column "accepted?"), also if today date is more then 30 days over the date of the reception of the record it should show "N" [not accepted] also in the

Can someone give me a tip as to how to solve this situation?

thank you

 

[namliam]

Empty is NULL or empty string, not a space....
Also try to prevent working with <>, it can make for a real puzzle with dealing with nulls and other stuff.....
try something like:
IIf(nz([Record number], "")="","",IIf((Date()-[Record Date])>30,"N","Y"))