Don't want to show records with NULL fields

[POLCATS]

Forgive me but I'm new to this. What I should have explained is that I have a report that I don't want any records that have null information in a particular field to show on the report. The report looks like this in the detail section;

[lastname][firstname][rank][tdy][tdyloction][tdydri][tdyreturn]

The report is not link to a query other than the expression in [tdyreturn] control source and it reads like =DateAdd("y",[TDY Length],[TDYDri])

I don't want the report to show any record that is missing a date in the [tdydri] section. Hopefully I explained myself better.

Ralph

 

[medic133]

I'm assuming that the above fields are from the same table. Couldn't you write a query that queries all of the fields with the criteria for each field, or just for the [tdydri] field, being Is Not Null? I think this would return values only where [tdydri] is not null. Then base your report on the query.
If your fields are not in the same table, just link them when you are designing the query. You may have to link your query for [tdyreturn] to the table(s) anyway. Good luck!