Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ontu78

    grouping formula

    Hello Ian and Lbass, I took both of your suggestions. Here is what I did: - Used the following SQL: select BU as "Entity", 'A' as "Type",Affiliate as "Entity2", Amount from Mytable union select Affiliate as "Entity", 'B' as "Type", BU as "Entity2", Amount from Mytable This results in the...
  2. ontu78

    grouping formula

    Thanks for your suggestion. The Bus Unit and Affiate values are actually characters ( as in GL01, GL02 etc). I'm somewhat confused as to how creating a formula field at the detail section and grouping by it, can enable the opposite Bus Unit/Affiliate to follow each other and calculate the...
  3. ontu78

    grouping formula

    Hello, We are currently in the process of designing a report from a table that has the following sample data Bus Unit Affiliate Amount ----------- ---------- ------------ 01 02 2500 01 03 2330 01...

Part and Inventory Search

Back
Top