Steve, Thanks for the reply on this.
My query is as follows:
SELECT Orders.[Selling Loc], Orders.[Enter Date], Orders.[Order #], Notes.Order, Orders.[Customer Name], Orders.[Ship To Name], Orders.[Customer PO No], Orders.[Total Order Amt], Orders.[Who Enter], Orders.Status, Orders.[Ship...