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 Shaun E 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: *

  • Users: dbware
  • Content: Threads
  • Order by date
  1. dbware

    Running Totals

    I have a report where a group is suppressed bases on the running total. This works fine. What I am having a problem with is that I also need an additional running Total Field at the end of the report where it will total all running totals from the unsuppressed groups. group not displayed pn...
  2. dbware

    I do not get it

    When I execute the following statement SELECT DISTINCT OEL.item_no, OEL.qty_to_ship AS 'Total quantity Sold', OEL.sls_amt FROM OEL INNER JOIN OEH ON OEL.ord_no = OEH.ord_no AND OEL.ord_type = OEH.ord_type WHERE OEH.cus_no = '000000000027' AND OEL.loc = 'SALES' ORDER BY OEL.item_no...
  3. dbware

    Stored Procedure

    I would like to know how I could write the following stored procedure step 1 read the data from database1 step 2 add the results from step 1 to database2. Note that fields in database1 are not necessary the same name as the fields in database2. step 3 write into a field from step 1 results...

Part and Inventory Search

Back
Top