Group Header On Null and not Null

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Report that I would like to Group on a Date [Ship Date]. So it will
be only two Groups.

1. That has dates in it.
2. That will have the one that do not have the dates in it.

As it is now it will group on the Null dates and then it will only do the
ones with dates by Date, Mo, Qtr or Year. I would like it to be just one
group.

Thanks

Keith
 
Set the sorting and grouping expression to:
=IsNull([Ship Date])
This expression will return only either True/-1 or False/0.
 
You can add another field to the record source of the report, that will mark
which records has date and which fields are null

Select Field1, Field2, [Ship Date] , IIf(isnull([Ship Date]),"No Date","Date
Exist") as GroupDate From TabelName ....

Make the group of the report based on the new field created "GroupDate"
 
Back
Top