Connecting Tech Pros Worldwide Help | Site Map

Separate Report Grouping Needed for Empty Fields

Newbie
 
Join Date: Aug 2007
Posts: 1
#1: Aug 24 '07
Hi. First time asking.

I have an Access report grouped by [city] and sub-grouped by [taxpayer]. For some records, though, the [taxpayer] field is empty.

The report works properly. However, my problem is that the "empty" [taxpayer] records are being grouped together under each city, and I would like them to be grouped SEPARATELY if they're empty.

I'm guessing I have to do something to the [taxpayer] field in the "On Format" event of the report's [taxpayer] header, but I have no idea what.

Anybody? Please.
msquared's Avatar
Administrator
 
Join Date: Aug 2006
Location: Dublin, Ireland
Posts: 10,865
#2: Sep 1 '07

re: Separate Report Grouping Needed for Empty Fields


To help you out we will need to know the SQL of the reports record source and any code you have in on format event of the report.
Reply


Similar Microsoft Access / VBA bytes