Recent content by Avalb1

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

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

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