Exclude Group + Summary the Excluded data

[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

 

[Guest]

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

 

[Marshall Barton]

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".

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")