Grouping Records...

  • Thread starter Thread starter Jim Wood
  • Start date Start date
J

Jim Wood

I have an Address Book report based on a query of names & addresses, etc. I
need to group the report into three sections based on whether the person is
a member (true/false) nonresident (true/false) or other (both of the
previous fields would be false) with each group starting on a new page.

Using the Sorting & Grouping Icon I am able to get the first two groups by
grouping on nonresident, but the third group (since it is a different type
of field??) is included in the first (resident) group instead of in a
seperate third group:

Resident Members:
name 1
name 2
name 3
...

<new page>
Non Resident Members:
name 1
name 2
name 3
...

<new page>
Other: <--- this group is missing and
it's members are included in group 1
name 1
name 2
name 3
...

Do I need to use a VBA procedure to properly sort the records into three
groups?

Thanks,

Jim
 
Jim:

I'm not sure I've got the full logic you really want to work with. Does
group 1, Residents = (Member = True + Resident = True) or can resident =
False, the same with group 2.

But to pick up definatively group three, then in your underlying query
create a field for the false/false situation using an IIF statement as in:

Other: IIF([Member]=False and [NonResident]=False, -1, 0)

That way you can choose the Other Field in the Sorting and grouping dialog.
 
Back
Top