Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Combine different lines to display beside each other

  1. #11
    Board Regular
    Join Date
    Aug 2009
    Posts
    140
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Combine different lines to display beside each other

    Maybe the only way to do this is in Excel and then put the table back into Access.
    I am tying to figure mean time between failure. My formula is this: IF(AND(A3=A2,C2<>"",B3-C2>0),B3-C2,"N/A")

    BarCode Date_Ent Date_Warranty Difference
    A-236639 7/3/2018 4/5/2019 49
    A-236639 5/24/2019 N/A
    A-325542 12/20/2018 4/15/2019 44
    A-325542 5/29/2019 N/A
    A-334869 4/10/2019 5/21/2019 7
    A-334869 5/28/2019 N/A
    A-335663 8/28/2018 1/31/2019 6
    A-335663 2/6/2019 3/28/2019 N/A
    A-335757 2/19/2019 3/14/2019 5
    A-335757 3/19/2019 4/22/2019 N/A
    A-335780 12/28/2018 3/8/2019 14
    A-335780 3/22/2019 4/30/2019 N/A
    A-336952 3/1/2019 4/29/2019 37
    A-336952 6/5/2019 N/A
    A-358773 1/7/2019 5/28/2019 N/A
    A-358773 5/28/2019 N/A
    A-360215 1/18/2019 4/26/2019 6
    A-360215 5/2/2019 5/22/2019 N/A
    A-360451 9/6/2018 2/20/2019 9
    A-360451 3/1/2019 4/18/2019 N/A
    A-360666 1/30/2019 4/25/2019 17
    A-360666 5/12/2019 N/A
    A-362214 1/21/2019 4/23/2019 1
    A-362214 4/24/2019 5/20/2019 2
    A-362214 5/22/2019 N/A

  2. #12
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    16,362
    Post Thanks / Like
    Mentioned
    10 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Combine different lines to display beside each other

    This last post is dramatically different from the first one --

    first post has four columns: RA_Num,BarCode,Date_Ent,Date_Warranty
    last post has four columns: BarCode,Date_Ent,Date_Warranty,Difference

    You will really have to restate what the problem is currently. You original said nothing about differences and only wanted side by side information. Are you now trying to do something different?

    Note that it probably is possible to do this in Access. But it will not be done in Access as if in a spreadsheet - using formulas based on the position of the rows and columns. However, if you want to export the data to Excel you certainly can implement this as a solution.

    Using: Office 2010/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

  3. #13
    Board Regular
    Join Date
    Aug 2009
    Posts
    140
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Combine different lines to display beside each other

    It is my mistake. I am trying to get the differences and thought by lining them side by side it would be easier in an Access table. I would rather do this in Access to keep all the data in one place. My last post is what I hoped to wind up with in the end. I probably need to delete this posting and restart.
    Sorry for the confusion

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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