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 IamaSherpa 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. DmikeR

    Duplicate Records due to one to many relationship

    Fixed my problem. Instead of Select I used Select Distinct in the store procedure. I then concat the sales order fields in one formula and daily production fields in another formula to suppress each formula using the Previous function.
  2. DmikeR

    Duplicate Records due to one to many relationship

    Thanks Ian for the tip. Unfortunately, I cannot provide all the heading information due to limited space of post. When I do what you suggested it would suppress information and suppress needed information. The example below SO# 1-4 shipdate and activity are suppressed because they are same from...
  3. DmikeR

    Duplicate Records due to one to many relationship

    shipDate SO# DailyProdDate DP# NetCases 1/1/08 1 1/1/08 1 10 1/1/08 2 1/1/08 3 1/2/08 4 1/2/08 2 11 1/2/08 3 12 1/3/08 4 12 1/3/08 5 13 1/4/08 5 1/4/08 6
  4. DmikeR

    Duplicate Records due to one to many relationship

    Here are the current results: shipDate SO# DailyProdDate DP# NetCases 1/1/08 1 1/1/08 1 10 1/1/08 2 1/1/08 1 10 1/1/08 3 1/1/08 1 10 1/2/08 4 1/2/08 2 11 1/2/08 4 1/2/08 3 12 1/3/08 4...
  5. DmikeR

    Duplicate Records due to one to many relationship

    The problem I am having is a little complex so I will try to keep it simple. The report will be exported to Excel. See below for store procedure. I created 4 temp tables. The #DateList table combines sales order dates and daily production dates so I can group on report by date. The other tables...

Part and Inventory Search

Back
Top