I have recently been working on a purchase order database in Access for work. This basically works with a purchase order details table containing normal order info like delivery date, delivery address, supplier name etc, then a subform which contains the individual item lines (product codes, descriptions, etc).
I then output it onto a report which uses a query as its source so that it only outputs the PO showing on the form at the time.
This all works splendidly except that when it outputs onto the report, if there are more than one product row on the subform, it will then repeat the results, as per below.
So if there's 3 items on the purchase order, it will show all items 3 times. If there's 4, it will show 4 times, etc..
Has anyone come across this before and know how to fix it please?


LinkBack URL
About LinkBacks
Reply With Quote

