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?

[TABLE="width: 258"]
<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>[TR]
[TD="width: 94, bgcolor: transparent"]RA_Num[/TD]
[TD="width: 73, bgcolor: transparent"]BarCode[/TD]
[TD="width: 76, bgcolor: transparent"]Date_Ent[/TD]
[TD="width: 100, bgcolor: transparent"]Date_Warranty[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RS07030128[/TD]
[TD="bgcolor: transparent"]A-236639[/TD]
[TD="bgcolor: transparent, align: right"]7/3/2018[/TD]
[TD="bgcolor: transparent, align: right"]4/5/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT05240124[/TD]
[TD="bgcolor: transparent"]A-236639[/TD]
[TD="bgcolor: transparent, align: right"]5/24/2019[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RS12200076[/TD]
[TD="bgcolor: transparent"]A-325542[/TD]
[TD="bgcolor: transparent, align: right"]12/20/2018[/TD]
[TD="bgcolor: transparent, align: right"]4/15/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT05290139[/TD]
[TD="bgcolor: transparent"]A-325542[/TD]
[TD="bgcolor: transparent, align: right"]5/29/2019[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT04100249[/TD]
[TD="bgcolor: transparent"]A-334869[/TD]
[TD="bgcolor: transparent, align: right"]4/10/2019[/TD]
[TD="bgcolor: transparent, align: right"]5/21/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT05280281[/TD]
[TD="bgcolor: transparent"]A-334869[/TD]
[TD="bgcolor: transparent, align: right"]5/28/2019[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RS08280184[/TD]
[TD="bgcolor: transparent"]A-335663[/TD]
[TD="bgcolor: transparent, align: right"]8/28/2018[/TD]
[TD="bgcolor: transparent, align: right"]1/31/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT02060109[/TD]
[TD="bgcolor: transparent"]A-335663[/TD]
[TD="bgcolor: transparent, align: right"]2/6/2019[/TD]
[TD="bgcolor: transparent, align: right"]3/28/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT02190119[/TD]
[TD="bgcolor: transparent"]A-335757[/TD]
[TD="bgcolor: transparent, align: right"]2/19/2019[/TD]
[TD="bgcolor: transparent, align: right"]3/14/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT03190145[/TD]
[TD="bgcolor: transparent"]A-335757[/TD]
[TD="bgcolor: transparent, align: right"]3/19/2019[/TD]
[TD="bgcolor: transparent, align: right"]4/22/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RS12280034[/TD]
[TD="bgcolor: transparent"]A-335780[/TD]
[TD="bgcolor: transparent, align: right"]12/28/2018[/TD]
[TD="bgcolor: transparent, align: right"]3/8/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT03220089[/TD]
[TD="bgcolor: transparent"]A-335780[/TD]
[TD="bgcolor: transparent, align: right"]3/22/2019[/TD]
[TD="bgcolor: transparent, align: right"]4/30/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT03010142[/TD]
[TD="bgcolor: transparent"]A-336952[/TD]
[TD="bgcolor: transparent, align: right"]3/1/2019[/TD]
[TD="bgcolor: transparent, align: right"]4/29/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT06050101[/TD]
[TD="bgcolor: transparent"]A-336952[/TD]
[TD="bgcolor: transparent, align: right"]6/5/2019[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT01070052[/TD]
[TD="bgcolor: transparent"]A-358773[/TD]
[TD="bgcolor: transparent, align: right"]1/7/2019[/TD]
[TD="bgcolor: transparent, align: right"]5/28/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT05280161[/TD]
[TD="bgcolor: transparent"]A-358773[/TD]
[TD="bgcolor: transparent, align: right"]5/28/2019[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT01180090[/TD]
[TD="bgcolor: transparent"]A-360215[/TD]
[TD="bgcolor: transparent, align: right"]1/18/2019[/TD]
[TD="bgcolor: transparent, align: right"]4/26/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT05020219[/TD]
[TD="bgcolor: transparent"]A-360215[/TD]
[TD="bgcolor: transparent, align: right"]5/2/2019[/TD]
[TD="bgcolor: transparent, align: right"]5/22/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RS09060234[/TD]
[TD="bgcolor: transparent"]A-360451[/TD]
[TD="bgcolor: transparent, align: right"]9/6/2018[/TD]
[TD="bgcolor: transparent, align: right"]2/20/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT03010097[/TD]
[TD="bgcolor: transparent"]A-360451[/TD]
[TD="bgcolor: transparent, align: right"]3/1/2019[/TD]
[TD="bgcolor: transparent, align: right"]4/18/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT01300086[/TD]
[TD="bgcolor: transparent"]A-360666[/TD]
[TD="bgcolor: transparent, align: right"]1/30/2019[/TD]
[TD="bgcolor: transparent, align: right"]4/25/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT05120051[/TD]
[TD="bgcolor: transparent"]A-360666[/TD]
[TD="bgcolor: transparent, align: right"]5/12/2019[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT01210130[/TD]
[TD="bgcolor: transparent"]A-362214[/TD]
[TD="bgcolor: transparent, align: right"]1/21/2019[/TD]
[TD="bgcolor: transparent, align: right"]4/23/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT04240052[/TD]
[TD="bgcolor: transparent"]A-362214[/TD]
[TD="bgcolor: transparent, align: right"]4/24/2019[/TD]
[TD="bgcolor: transparent, align: right"]5/20/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT05220057[/TD]
[TD="bgcolor: transparent"]A-362214[/TD]
[TD="bgcolor: transparent, align: right"]5/22/2019[/TD]
[TD="bgcolor: transparent"]
[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 263"]
<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>[TR]
[TD="width: 99, bgcolor: transparent"]RA_Num[/TD]
[TD="width: 76, bgcolor: transparent"]BarCode[/TD]
[TD="width: 76, bgcolor: transparent"]Date_Ent[/TD]
[TD="width: 100, bgcolor: transparent"]Date_Warranty[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RS07030128[/TD]
[TD="bgcolor: transparent"]A-236639[/TD]
[TD="bgcolor: transparent, align: right"]7/3/2018[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT05240124[/TD]
[TD="bgcolor: transparent"]A-236639[/TD]
[TD="bgcolor: transparent, align: right"]5/24/2019[/TD]
[TD="bgcolor: transparent, align: right"]4/5/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RS12200076[/TD]
[TD="bgcolor: transparent"]A-325542[/TD]
[TD="bgcolor: transparent, align: right"]12/20/2018[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT05290139[/TD]
[TD="bgcolor: transparent"]A-325542[/TD]
[TD="bgcolor: transparent, align: right"]5/29/2019[/TD]
[TD="bgcolor: transparent, align: right"]4/15/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT04100249[/TD]
[TD="bgcolor: transparent"]A-334869[/TD]
[TD="bgcolor: transparent, align: right"]4/10/2019[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT05280281[/TD]
[TD="bgcolor: transparent"]A-334869[/TD]
[TD="bgcolor: transparent, align: right"]5/28/2019[/TD]
[TD="bgcolor: transparent, align: right"]5/21/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RS08280184[/TD]
[TD="bgcolor: transparent"]A-335663[/TD]
[TD="bgcolor: transparent, align: right"]8/28/2018[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT02060109[/TD]
[TD="bgcolor: transparent"]A-335663[/TD]
[TD="bgcolor: transparent, align: right"]2/6/2019[/TD]
[TD="bgcolor: transparent, align: right"]1/31/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT02190119[/TD]
[TD="bgcolor: transparent"]A-335757[/TD]
[TD="bgcolor: transparent, align: right"]2/19/2019[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT03190145[/TD]
[TD="bgcolor: transparent"]A-335757[/TD]
[TD="bgcolor: transparent, align: right"]3/19/2019[/TD]
[TD="bgcolor: transparent, align: right"]3/14/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RS12280034[/TD]
[TD="bgcolor: transparent"]A-335780[/TD]
[TD="bgcolor: transparent, align: right"]12/28/2018[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT03220089[/TD]
[TD="bgcolor: transparent"]A-335780[/TD]
[TD="bgcolor: transparent, align: right"]3/22/2019[/TD]
[TD="bgcolor: transparent, align: right"]3/8/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT03010142[/TD]
[TD="bgcolor: transparent"]A-336952[/TD]
[TD="bgcolor: transparent, align: right"]3/1/2019[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT06050101[/TD]
[TD="bgcolor: transparent"]A-336952[/TD]
[TD="bgcolor: transparent, align: right"]6/5/2019[/TD]
[TD="bgcolor: transparent, align: right"]4/29/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT01070052[/TD]
[TD="bgcolor: transparent"]A-358773[/TD]
[TD="bgcolor: transparent, align: right"]1/7/2019[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT05280161[/TD]
[TD="bgcolor: transparent"]A-358773[/TD]
[TD="bgcolor: transparent, align: right"]5/28/2019[/TD]
[TD="bgcolor: transparent, align: right"]5/28/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT01180090[/TD]
[TD="bgcolor: transparent"]A-360215[/TD]
[TD="bgcolor: transparent, align: right"]1/18/2019[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT05020219[/TD]
[TD="bgcolor: transparent"]A-360215[/TD]
[TD="bgcolor: transparent, align: right"]5/2/2019[/TD]
[TD="bgcolor: transparent, align: right"]4/26/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RS09060234[/TD]
[TD="bgcolor: transparent"]A-360451[/TD]
[TD="bgcolor: transparent, align: right"]9/6/2018[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT03010097[/TD]
[TD="bgcolor: transparent"]A-360451[/TD]
[TD="bgcolor: transparent, align: right"]3/1/2019[/TD]
[TD="bgcolor: transparent, align: right"]2/20/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT01300086[/TD]
[TD="bgcolor: transparent"]A-360666[/TD]
[TD="bgcolor: transparent, align: right"]1/30/2019[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT05120051[/TD]
[TD="bgcolor: transparent"]A-360666[/TD]
[TD="bgcolor: transparent, align: right"]5/12/2019[/TD]
[TD="bgcolor: transparent, align: right"]4/25/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT01210130[/TD]
[TD="bgcolor: transparent"]A-362214[/TD]
[TD="bgcolor: transparent, align: right"]1/21/2019[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT04240052[/TD]
[TD="bgcolor: transparent"]A-362214[/TD]
[TD="bgcolor: transparent, align: right"]4/24/2019[/TD]
[TD="bgcolor: transparent, align: right"]4/23/2019[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]RT05220057[/TD]
[TD="bgcolor: transparent"]A-362214[/TD]
[TD="bgcolor: transparent, align: right"]5/22/2019[/TD]
[TD="bgcolor: transparent, align: right"]5/20/2019[/TD]
[/TR]
</tbody>[/TABLE]

 

[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")

[TABLE="width: 231"]
<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>[TR]
[TD="width: 63, bgcolor: transparent"]BarCode[/TD]
[TD="width: 76, bgcolor: transparent"]Date_Ent[/TD]
[TD="width: 100, bgcolor: transparent"]Date_Warranty[/TD]
[TD="width: 69, bgcolor: transparent"]Difference[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A-236639[/TD]
[TD="bgcolor: transparent, align: right"]7/3/2018[/TD]
[TD="bgcolor: transparent, align: right"]4/5/2019[/TD]
[TD="bgcolor: transparent, align: right"]49[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A-236639[/TD]
[TD="bgcolor: transparent, align: right"]5/24/2019[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A-325542[/TD]
[TD="bgcolor: transparent, align: right"]12/20/2018[/TD]
[TD="bgcolor: transparent, align: right"]4/15/2019[/TD]
[TD="bgcolor: transparent, align: right"]44[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A-325542[/TD]
[TD="bgcolor: transparent, align: right"]5/29/2019[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A-334869[/TD]
[TD="bgcolor: transparent, align: right"]4/10/2019[/TD]
[TD="bgcolor: transparent, align: right"]5/21/2019[/TD]
[TD="bgcolor: transparent, align: right"]7[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A-334869[/TD]
[TD="bgcolor: transparent, align: right"]5/28/2019[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A-335663[/TD]
[TD="bgcolor: transparent, align: right"]8/28/2018[/TD]
[TD="bgcolor: transparent, align: right"]1/31/2019[/TD]
[TD="bgcolor: transparent, align: right"]6[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A-335663[/TD]
[TD="bgcolor: transparent, align: right"]2/6/2019[/TD]
[TD="bgcolor: transparent, align: right"]3/28/2019[/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A-335757[/TD]
[TD="bgcolor: transparent, align: right"]2/19/2019[/TD]
[TD="bgcolor: transparent, align: right"]3/14/2019[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A-335757[/TD]
[TD="bgcolor: transparent, align: right"]3/19/2019[/TD]
[TD="bgcolor: transparent, align: right"]4/22/2019[/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A-335780[/TD]
[TD="bgcolor: transparent, align: right"]12/28/2018[/TD]
[TD="bgcolor: transparent, align: right"]3/8/2019[/TD]
[TD="bgcolor: transparent, align: right"]14[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A-335780[/TD]
[TD="bgcolor: transparent, align: right"]3/22/2019[/TD]
[TD="bgcolor: transparent, align: right"]4/30/2019[/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A-336952[/TD]
[TD="bgcolor: transparent, align: right"]3/1/2019[/TD]
[TD="bgcolor: transparent, align: right"]4/29/2019[/TD]
[TD="bgcolor: transparent, align: right"]37[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A-336952[/TD]
[TD="bgcolor: transparent, align: right"]6/5/2019[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A-358773[/TD]
[TD="bgcolor: transparent, align: right"]1/7/2019[/TD]
[TD="bgcolor: transparent, align: right"]5/28/2019[/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A-358773[/TD]
[TD="bgcolor: transparent, align: right"]5/28/2019[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A-360215[/TD]
[TD="bgcolor: transparent, align: right"]1/18/2019[/TD]
[TD="bgcolor: transparent, align: right"]4/26/2019[/TD]
[TD="bgcolor: transparent, align: right"]6[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A-360215[/TD]
[TD="bgcolor: transparent, align: right"]5/2/2019[/TD]
[TD="bgcolor: transparent, align: right"]5/22/2019[/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A-360451[/TD]
[TD="bgcolor: transparent, align: right"]9/6/2018[/TD]
[TD="bgcolor: transparent, align: right"]2/20/2019[/TD]
[TD="bgcolor: transparent, align: right"]9[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A-360451[/TD]
[TD="bgcolor: transparent, align: right"]3/1/2019[/TD]
[TD="bgcolor: transparent, align: right"]4/18/2019[/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A-360666[/TD]
[TD="bgcolor: transparent, align: right"]1/30/2019[/TD]
[TD="bgcolor: transparent, align: right"]4/25/2019[/TD]
[TD="bgcolor: transparent, align: right"]17[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A-360666[/TD]
[TD="bgcolor: transparent, align: right"]5/12/2019[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A-362214[/TD]
[TD="bgcolor: transparent, align: right"]1/21/2019[/TD]
[TD="bgcolor: transparent, align: right"]4/23/2019[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A-362214[/TD]
[TD="bgcolor: transparent, align: right"]4/24/2019[/TD]
[TD="bgcolor: transparent, align: right"]5/20/2019[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]A-362214[/TD]
[TD="bgcolor: transparent, align: right"]5/22/2019[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]N/A[/TD]
[/TR]
</tbody>[/TABLE]

 

[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