"other" group

[Guest]

I have a report containing data on several different tax types. There are a
dozen or more possilble type of tax. However, there are two types that make
up the majority of the entries. How can I gather all of the lesser tax
types under the "Other" group heading.

Something Like:
Franchise Tax
line 1
lines ...
Sales Tax
line 1
lines ...
Other Taxes
line 1
lines ...


One thought I had was to add another field to the table (or link one into
the query) for a separate tax sorting entry. franchise would = 1, sales
would =2, then all of the other tax types would =3.

Does anybody have a better idea?

Thanks
Rae Lynn

 

[Al Camp]

Rae,
Your idea is just fine!
However, you don't have to add a field to your table... you can do it "on
the fly"

(I'm assuming you have a field that identifies each tax as Franchise or
Sales or etc... something like a [TaxType]. If you don't, you probably
should.

In the query behind your report craete a calculated field in a column
like this... (assuming a numeric TaxType)
TaxGrp : IIF(TaxType = "Franchise Tax", 1, IIF(TaxType = "Sales Tax", 2,3))

Now group your report on TaxGrp.

 

[Guest]

That's what I needed. I have a problem with IIFs, so thanks for the
confirmation and help.

Rae,
Your idea is just fine!
However, you don't have to add a field to your table... you can do it "on
the fly"

(I'm assuming you have a field that identifies each tax as Franchise or
Sales or etc... something like a [TaxType]. If you don't, you probably
should.

In the query behind your report craete a calculated field in a column
like this... (assuming a numeric TaxType)
TaxGrp : IIF(TaxType = "Franchise Tax", 1, IIF(TaxType = "Sales Tax", 2,3))

Now group your report on TaxGrp.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

I have a report containing data on several different tax types. There are
a
dozen or more possilble type of tax. However, there are two types that
make
up the majority of the entries. How can I gather all of the lesser tax
types under the "Other" group heading.

Something Like:
Franchise Tax
line 1
lines ...
Sales Tax
line 1
lines ...
Other Taxes
line 1
lines ...


One thought I had was to add another field to the table (or link one into
the query) for a separate tax sorting entry. franchise would = 1, sales
would =2, then all of the other tax types would =3.

Does anybody have a better idea?

Thanks
Rae Lynn

 

[Al Camp]

Rae,
My previous post should have said... (assuming Text)
Glad you got it going...
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

That's what I needed. I have a problem with IIFs, so thanks for the
confirmation and help.

Rae,
Your idea is just fine!
However, you don't have to add a field to your table... you can do it
"on
the fly"

(I'm assuming you have a field that identifies each tax as Franchise
or
Sales or etc... something like a [TaxType]. If you don't, you probably
should.

In the query behind your report craete a calculated field in a column
like this... (assuming a numeric TaxType)
TaxGrp : IIF(TaxType = "Franchise Tax", 1, IIF(TaxType = "Sales Tax",
2,3))

Now group your report on TaxGrp.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

I have a report containing data on several different tax types. There
are
a
dozen or more possilble type of tax. However, there are two types
that
make
up the majority of the entries. How can I gather all of the lesser
tax
types under the "Other" group heading.

Something Like:
Franchise Tax
line 1
lines ...
Sales Tax
line 1
lines ...
Other Taxes
line 1
lines ...


One thought I had was to add another field to the table (or link one
into
the query) for a separate tax sorting entry. franchise would = 1,
sales
would =2, then all of the other tax types would =3.

Does anybody have a better idea?

Thanks
Rae Lynn