Combine different lines to display beside each other

[Tcurtis]

I am not sure how to ask this question. I want to display two different date fields of data beside each other. They have the same unique serial number/barcode and the dates are on separate lines. I want to display them on the same line beside each other. The first example shows how the data looks. The second shows how I want to display it. How do I move the dates side by side?

RA_Num	BarCode	Date_Ent	Date_Warranty
RS07030128	A-236639	7/3/2018	4/5/2019
RT05240124	A-236639	5/24/2019
RS12200076	A-325542	12/20/2018	4/15/2019
RT05290139	A-325542	5/29/2019
RT04100249	A-334869	4/10/2019	5/21/2019
RT05280281	A-334869	5/28/2019
RS08280184	A-335663	8/28/2018	1/31/2019
RT02060109	A-335663	2/6/2019	3/28/2019
RT02190119	A-335757	2/19/2019	3/14/2019
RT03190145	A-335757	3/19/2019	4/22/2019
RS12280034	A-335780	12/28/2018	3/8/2019
RT03220089	A-335780	3/22/2019	4/30/2019
RT03010142	A-336952	3/1/2019	4/29/2019
RT06050101	A-336952	6/5/2019
RT01070052	A-358773	1/7/2019	5/28/2019
RT05280161	A-358773	5/28/2019
RT01180090	A-360215	1/18/2019	4/26/2019
RT05020219	A-360215	5/2/2019	5/22/2019
RS09060234	A-360451	9/6/2018	2/20/2019
RT03010097	A-360451	3/1/2019	4/18/2019
RT01300086	A-360666	1/30/2019	4/25/2019
RT05120051	A-360666	5/12/2019
RT01210130	A-362214	1/21/2019	4/23/2019
RT04240052	A-362214	4/24/2019	5/20/2019
RT05220057	A-362214	5/22/2019

<colgroup><col width="94" style="width: 71pt; mso-width-source: userset; mso-width-alt: 3356;"> <col width="73" style="width: 55pt; mso-width-source: userset; mso-width-alt: 2588;"> <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;"> <tbody> </tbody>

RA_Num	BarCode	Date_Ent	Date_Warranty
RS07030128	A-236639	7/3/2018
RT05240124	A-236639	5/24/2019	4/5/2019
RS12200076	A-325542	12/20/2018
RT05290139	A-325542	5/29/2019	4/15/2019
RT04100249	A-334869	4/10/2019
RT05280281	A-334869	5/28/2019	5/21/2019
RS08280184	A-335663	8/28/2018
RT02060109	A-335663	2/6/2019	1/31/2019
RT02190119	A-335757	2/19/2019
RT03190145	A-335757	3/19/2019	3/14/2019
RS12280034	A-335780	12/28/2018
RT03220089	A-335780	3/22/2019	3/8/2019
RT03010142	A-336952	3/1/2019
RT06050101	A-336952	6/5/2019	4/29/2019
RT01070052	A-358773	1/7/2019
RT05280161	A-358773	5/28/2019	5/28/2019
RT01180090	A-360215	1/18/2019
RT05020219	A-360215	5/2/2019	4/26/2019
RS09060234	A-360451	9/6/2018
RT03010097	A-360451	3/1/2019	2/20/2019
RT01300086	A-360666	1/30/2019
RT05120051	A-360666	5/12/2019	4/25/2019
RT01210130	A-362214	1/21/2019
RT04240052	A-362214	4/24/2019	4/23/2019
RT05220057	A-362214	5/22/2019	5/20/2019

<colgroup><col width="99" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3527;"> <col width="76" style="width: 57pt; mso-width-source: userset; mso-width-alt: 2702;" span="2"> <col width="100" style="width: 75pt; mso-width-source: userset; mso-width-alt: 3555;"> <tbody> </tbody>

 

[Tcurtis]

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

<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>

 

[xenou]

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]

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