Reporting Function

N

Neal

I am trying to create a summary report that includes a date field. However
only some of the fields are populated. Is there an if then statement in a
queery that will only admit the fields with a date?

Thanks,

Neal
 
D

Dirk Goldgar

Neal said:
I am trying to create a summary report that includes a date field.
However only some of the fields are populated. Is there an if then
statement in a queery that will only admit the fields with a date?
Click to expand...

I'm not sure what you're looking for, exactly, but you can certainly set
your report's recordsource query to include only those records WHERE
[YourDateField] IS NOT NULL .
 
Top