Link to home
Start Free TrialLog in
Avatar of apophis_nfld
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!
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

What problem are you having?
I would expect the nulls to get grouped together.
Avatar of apophis_nfld
apophis_nfld

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
Avatar of kirenievs
kirenievs
Flag of Sweden image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks!