First Occurrence of a Number
First Occurrence of a Number
(OP)
CR v9/Peachtree 2006/Btrieve
I have a report that lists invoices with the following columns:
invoice #
invoice date
customer name
invoice amount
The report is not for a specific date range, it is just a history of all the invoices for the company.
How can I find the first cccurrence of an invoice amount, like $5000.00? When the first occurrence is found, I want to print the invoice #, invoice date, customer name and invoice amount in the report footer. Is there a formula I can create to do this?
I have a report that lists invoices with the following columns:
invoice #
invoice date
customer name
invoice amount
The report is not for a specific date range, it is just a history of all the invoices for the company.
How can I find the first cccurrence of an invoice amount, like $5000.00? When the first occurrence is found, I want to print the invoice #, invoice date, customer name and invoice amount in the report footer. Is there a formula I can create to do this?
Talk To Other Members
RE: First Occurrence of a Number
Bill Couture
SBTBILL.COM
RE: First Occurrence of a Number
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
www.gainfocus.biz
"making predictions is tough, especially about the future" - Yogi Berra