The link you are using must be an outer join to show all of the entries from one table and only the entries related to them from the other. This will show your Loan# even if there are no trades in the date range. the Message No Trades could be a conditional statement based on the total amount of the trades If it is 0 disolay “no Trades” else display the toal of the amount traded.
Hope this helps.
Thanks Julie – that fixed the problem!!