Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2016
    Posts
    1

    Unanswered: Getting additional records in column vs new row

    I am looking to see how i alter my results without recreating too much. I am not an advanced developer, just a basic user trying to get results, so any assistance is appreciated.

    Current Results


    [00 - DC].Date [00 - DC].WebOrderID [00 - DC].[Item Description] / WMOH.WMSData WMOH.Location
    3/18/2016 564529 RSG-609465228876 SA-09-06-23
    3/18/2016 564529 RSG-609465228876 SA-05-07-13
    3/18/2016 564529 RSG-609465228876 SA-14-36-22


    Expected Results

    [00 - DC].Date [00 - DC].WebOrderID [00 - DC].[Item Description] / WMOH.WMSData WMOH.Location 1 WMOH.Location 2 WMOH.Location 3
    3/18/2016 564529 RSG-609465228876 SA-09-06-23 SA-05-07-13 SA-14-36-22


    Click image for larger version. 

Name:	Query Relationship.jpg 
Views:	7 
Size:	27.2 KB 
ID:	16821

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    496
    Provided Answers: 24
    That is a crosstab query...use the qry wizard to make if from your data query above...

    set the value field to FIRST

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •