Exclude Group + Summary the Excluded data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'd like to make a report in which there are several static fields.

House Finch
House Sparrow
Song Sparrow
White-Crn. Sparrow
Crow
Other Species

Those are the only groups I would like data for. Anything that isnt HF, HS,
SS, WCS, or C should be lumped into "Other Species".

I've been frustrated over this for awhile, any help would be appreciated
 
You can create three queries
1. Select GroupName as myGroup, field1, field2, field2 From MyTable Where
GroupName in("HF","HS"...)

2. Select "Other Species" as myGroup, field1, field2, field2 From MyTable
Where GroupName not in("HF","HS"...)

3. Union query to include both queries
==========================================
Another way creatin one query with iif for the name of the group, with a
group by

Select
IIF(GroupName="HF","HF",IIF(GroupName="HS","HS",IIF(GroupName="SS","SS",IIF(GroupName="WCS","WCS",IIF(GroupName="C","C","Other
Species"))))) as GroupName, Field2, Field3 ... From MyTable
 
Brandon said:
I'd like to make a report in which there are several static fields.

House Finch
House Sparrow
Song Sparrow
White-Crn. Sparrow
Crow
Other Species

Those are the only groups I would like data for. Anything that isnt HF, HS,
SS, WCS, or C should be lumped into "Other Species".
Click to expand...


Not sure I understand, but it sounds like you want to use
Sorting and Grouping om the expression:

=IIf(specie In ("HF","HS","SS","WCS","C"), specie, "Others")
 
Back
Top