Grouping and Sorting

  • Thread starter Thread starter gst
  • Start date Start date
G

gst

I would like to recreate a text file Invoice for my billing system. I have
been able to successfully reproduce all of the fields in the sample invoice
except for the invoice Number. The numbering scheme is a little difficult for
me to create. I was hoping the Grouping and sorting button would work, but I
am still not coming up with the correct data. I need the Invoice Number to
stay the same as long as the Account Number is the same. When the Account
Number changes, then I would like to increment the invoice Number. Any
suggestions would save my life!

I have included sample data below.

Thank you!!

Invoice Account Charge Description
Number Number
01 0000000401 47.96 Monthly service fee
01 0000000401 3.24 Tax@ 0.0675%
01 0000000401 51.20 "ADAMESCU,PHILLIP"
02 0000000111 47.96 Monthly service fee
02 0000000111 3.12 Tax@ 0.065%
02 0000000111 51.08 abbott,william
03 0000000221 47.96 Monthly service fee
03 0000000221 3.12 Tax@ 0.065%
03 0000000221 51.08 "KIMBALL,ROBERTA"
04 0000000551 47.96 Monthly service fee
04 0000000551 3.24 Tax@ 0.0675%
04 0000000551 51.20 "ADAMS,CHAD"
05 0000000821 47.96 Monthly service fee
05 0000000821 3.24 Tax@ 0.0675%
05 0000000821 51.20 "ADAMS,THERESA"
 
Hi,

What are the pertinent tables and fields in your database that is the
source of the invoicing information? What is the query, if any, that is the
source of the report? Are you saying that you do not store the invoice
number anywhere? If not, why not?

Clifford Bass
 
Back
Top