Age in days

[lmossolle]

I have a table with Date_Rec and Date_Awarded i would like the followig in
days;

Date_Rec-Date() Where Date_Awarded = "Null"

Could someone assist?

 

[Duane Hookom]

A date field can't equal the string "Null". Actually you can't compare any
value to Null since Null is about the same as unknown.

If you want to check for null, use:
WHERE [Some Field Name] Is Null

 

[John W. Vinson]

I have a table with Date_Rec and Date_Awarded i would like the followig in
days;

Date_Rec-Date() Where Date_Awarded = "Null"

Could someone assist?

Use a criterion of

IS NULL

just as I wrote it, with no = or quotes, on the Date_Awarded field; and

Age: DateDiff("d", [Date_Rec], Date())

as a calculated field.