For our needs, it's perfect EXCEPT for the fact that it duplicates many of
the rows because of multiple InvoiceItems associated with some of the
InvoiceIDs. At the following address are two of these reports--one that
works just fine (if I leave out the Invoice.Amount (Amount Due) and leave
out the Invoices/InvoiceItems.InvoiceID); the other displays the multiple
rows for any invoice that contained more than one InvoiceItems.ItemID.
Daily-Payments.rpt (works correctly, but lacks InvoiceID
Daily-Payments2.rpt (doesn't work correctly)
Does anyone know how to fix this? It seems like something so simple, yet I
can't figure it out. I have a plain SQL script that performs all of this
stuff correctly using SELECT DISTINCT, but I can't seem to add "DISTINCT"
to the report SQL query.
Thanks for any help...