Access 2003 Report Group By Field Value

Posted on 2009-05-21
Medium Priority
Last Modified: 2013-11-28
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!
Question by:apophis_nfld
  • 2
  • 2
LVL 77

Expert Comment

ID: 24440620
What problem are you having?
I would expect the nulls to get grouped together.

Author Comment

ID: 24441064
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.
LVL 77

Expert Comment

ID: 24442044
Just group on the field . There 's no need to use any ifs.
LVL 10

Accepted Solution

kirenievs earned 2000 total points
ID: 24469525
In the group box

=IIF(isnull([fieldName], "This is null", "This is not null")


In the recordsource of the report:

MyGroupField: IIF(isnull([fieldName], "This is null", "This is not null")

/Svein Erik

Author Closing Comment

ID: 31583895

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question