"other" group

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

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
 
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.
 
That's what I needed. I have a problem with IIFs, so thanks for the
confirmation and help.

Al Camp said:
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

Rae Lynn Tipping said:
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
Click to expand...
Click to expand...
 
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


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

Al Camp said:
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

Rae Lynn Tipping said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top