Combine different lines to display beside each other

Tcurtis

Board Regular
Joined
Aug 15, 2009
Messages
144
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")

BarCodeDate_EntDate_WarrantyDifference
A-2366397/3/20184/5/201949
A-2366395/24/2019N/A
A-32554212/20/20184/15/201944
A-3255425/29/2019N/A
A-3348694/10/20195/21/20197
A-3348695/28/2019N/A
A-3356638/28/20181/31/20196
A-3356632/6/20193/28/2019N/A
A-3357572/19/20193/14/20195
A-3357573/19/20194/22/2019N/A
A-33578012/28/20183/8/201914
A-3357803/22/20194/30/2019N/A
A-3369523/1/20194/29/201937
A-3369526/5/2019N/A
A-3587731/7/20195/28/2019N/A
A-3587735/28/2019N/A
A-3602151/18/20194/26/20196
A-3602155/2/20195/22/2019N/A
A-3604519/6/20182/20/20199
A-3604513/1/20194/18/2019N/A
A-3606661/30/20194/25/201917
A-3606665/12/2019N/A
A-3622141/21/20194/23/20191
A-3622144/24/20195/20/20192
A-3622145/22/2019N/A
<colgroup><col width="63" style="width: 47pt; mso-width-source: userset; mso-width-alt: 2247;"> <col width="76" style="width: 57pt; mso-width-source: userset; mso-width-alt: 2702;"> <col width="100" style="width: 75pt; mso-width-source: userset; mso-width-alt: 3555;"> <col width="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2446;"> <tbody> </tbody>
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

xenou

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,628
Office Version
2013
Platform
Windows
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.
 

Tcurtis

Board Regular
Joined
Aug 15, 2009
Messages
144
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
 

Watch MrExcel Video

Forum statistics

Threads
1,095,840
Messages
5,446,814
Members
405,415
Latest member
Noodnutt

This Week's Hot Topics

Top