apophis_nfld
asked on
Access 2003 Report Group By Field Value
I have a varchar field which has either a value or is null. I want my report to group the records with this field = null together and group the records which have the field not null together. Please help!
ASKER
I don't know how to create an if statement in the group box inside access. I was hoping to get a report section for nulls and a report section for not nulls.
Just group on the field . There 's no need to use any ifs.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!
I would expect the nulls to get grouped together.