 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / September 2005"other" group
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.  Signaturehth 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 [quoted text clipped - 22 lines] > Thanks > Rae Lynn That's what I needed. I have a problem with IIFs, so thanks for the confirmation and help. > Rae, > Your idea is just fine! [quoted text clipped - 36 lines] > > Thanks > > Rae Lynn Rae, >> In the query behind your report craete a calculated field in a column >> like this... (assuming a numeric TaxType) 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. [quoted text clipped - 47 lines] >> > Thanks >> > Rae Lynn |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.