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!

  • Congratulations Westi 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. dnagahawatte

    Running Total By Group

    Thanks for ur reply, Ur solution is not practical only because i have more than 100 client groups on the database and not all of them appear on the report monthly, also these client groups getting added to the database on daily basis, so i cannt afford to change the report all the time. Any...
  2. dnagahawatte

    Running Total By Group

    Thanks you for ur response I have a runnig total for each and every ClientGroup but resets at the change of client group. Which works fine for the "total of M&S for JAN" and "total of M&S for FEB" and so on. But i want is a runnig total of M&S not to reset at all and a runnig total of Tesco not...
  3. dnagahawatte

    Running Total By Group

    I have a report that has many Client Groups and costs incurred by client group. I have grouped this record by Client Group and now want a runnig total for each and every Client group. I tried evaluate the running total by the Client_Group Field at change of field but does not work. Can someone...
  4. dnagahawatte

    Difference of two tables

    Hi All; Say i have two tables. PartsTable1, PartsTable2 PartsTable1 has two columns (PartNo, Qty) PartsTable2 also have two columns (PartNo, Qty) PartsTable1 ----------- PartNo Qty 558 - 5 658 - 6 788 - 10 PartsTable2 PartNo Qty 558 - 10 658 - 8 788 - 10 999...
  5. dnagahawatte

    Select only 1 raw each for a product

    Excellent, Thanks both of you!
  6. dnagahawatte

    Select only 1 raw each for a product

    Dear support; If i have a prodyct table with different product instances with the same product name and all those instances have a different price; How can i only select product instances with the highest price. Product / Name / Price Car - BMW £10000 Car - MB £15000 Car -...

Part and Inventory Search

Back
Top