Access QRY

[Avalb1]

Need help with my QRY.
I have a Linked table with the below fields,

Amount. Record number
$25000. NTB12345
$25000. NTB45670
$25000. NTB45321

When I run my QRY I get
$25000. NTB12345
$25000. NTB12345
$25000. NTB12345
How can I get my QRY to show the amount with
The related record number

 

[pbaldy]

What is the SQL of your query?

 

[Avalb1]

SELECT [739 data].[Open Amount], [739 data].Aging, [Combined Trades].[Security ID], [Combined Trades].[Transaction Number], IIf([Aging]>6,"TICKET PASSED TO CPSS, C/P SHORT SHARES",[Fail Description]) AS [Fail Desc], [739 data].[Description / Cusip], [739 data].[Management Explanation]
FROM ([739 data] LEFT JOIN [Combined Trades] ON [739 data].[Open Amount] = [Combined Trades].[Net Amount]) LEFT JOIN [Settled Trades - Wizard Report] ON [739 data].[Open Amount] = [Settled Trades - Wizard Report].[Net Amount]
WHERE ((([739 data].[Description / Cusip]) Like "GS*"));

 

[pbaldy]

Which field are you calling record number, since none of them would have that name? You actually join on amounts? They are unique?

 

[Avalb1]

Hello Paul,
Thanks for taking time to assist. Transaction number is the field I'm calling record number.