Question on Left Join Query Results

[jjones100]

I have two tables, PendingOrders and SubformTbl. Here is the join: LEFT JOIN SubformTbl ON PendingOrders.PONumber = SubformTbl.PONumber. I would like for the orders in the PendingOrders table to be displayed just once for each of the SubformTbl records. PONumber, Custname, FMS# come from PendingOrders and OrderReq & LOC come from SubformTbl.It displays as(top line are col headings):
PONumber CustName FMS# OrderReq LOC

RF001 Rosemont Farms 71107426 Ckt Related 8909867
RF001 Rosemont Farms 71107426 MNS
RF001 Rosemont Farms 71107426 MNS 2307584
RF001 Rosemont Farms 71107426 MNS
RF001 Rosemont Farms 71107426 MNS

I would like to remove the duplicate Custname & FMS number from the results. I actually have several additional columns to remove, but for simplicity am only including these two.
Can I do this? Thanks for any help

 

[PHV]

Do it in a report.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886