[Emerald] Query for last payment and missing InvoiceID in Payments table..

Billy Huddleston ( (no email) )
Mon, 15 May 2000 10:01:10 -0400

Trying to write a query to bring up the very last payment for a customer
(for use in invoice.rpt in Crystal Reports) because the existing method
found in the supplied report doesn't work. It searches through the Payments
table looking for a matching InvoiceID and none of the Payments have a
InvoiceID, and I really don't understand how that would bring up the last
payment anyways...

Thanks, Billy

+--------------------------------------------------+
| Billy Huddleston System Administrator |
| Net-Express http://www.nxs.net |
| 114 Sherway Rd. Voice: 865-691-2011 |
| Knoxville, TN 37922 Fax: 865-691-9894 |
| billy@nxs.net |
+--------------------------------------------------+

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart