I have a report that is looking at field "a" ( a date field) for data. Field A initially is blank but when it gets populated and the report is reran it give me 2 pages 1 with the field blank and 1 with the field populated any ideas how I can eliminate the blank field page? as a side note I do want the blank field page to show if someone has this field empty as it is will need to be updated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
date field question
- Thread starter timISST
- Start date
IanWaterman
Programmer
In select expert filter out the Null fields
Not(isnull(yourdatefield))
Ian
Not(isnull(yourdatefield))
Ian
- Status
Similar threads
- Locked
- Question
- Locked
- Question