AutoNumber

I would never use reports to create Invoice numbers. Use code and/or queries
to add invoice numbers to your existing records and then filter your report
based on the existing invoice numbers.

--
Duane Hookom
MS Access MVP


"Sheryl" wrote in message
...
I need to add an Invoice (AutoNumber) to a report. How do I do this so
that the number will automatically insert itself into the report already
sorted and grouped? And if needed the report can be searched based on that
Invoice Number?

That works out well if you are sorting by Invoice numbers. I have to sort by "Bill To" numbers. There are multiple stores using one "Bill To" number though they are located all over Texas, it would be chaotic to bill each store individually to the "BIll To" number, as well as a waste of a good tree.

----- Duane Hookom wrote: -----

I would never use reports to create Invoice numbers. Use code and/or queries
to add invoice numbers to your existing records and then filter your report
based on the existing invoice numbers.

--
Duane Hookom
MS Access MVP


"Sheryl" wrote in message
...
I need to add an Invoice (AutoNumber) to a report. How do I do this so
that the number will automatically insert itself into the report already
sorted and grouped? And if needed the report can be searched based on that
Invoice Number?

I missed any mention of "Bill To" in your previous message. My solution was
to use code or some other method to create your invoice numbers and store
them in a table. Then just run the report with the invoice numbers already
calculated.

--
Duane Hookom
MS Access MVP
--

"Sheryl" wrote in message
...
That works out well if you are sorting by Invoice numbers. I have to sort
by "Bill To" numbers. There are multiple stores using one "Bill To" number
though they are located all over Texas, it would be chaotic to bill each
store individually to the "BIll To" number, as well as a waste of a good
tree.

----- Duane Hookom wrote: -----

I would never use reports to create Invoice numbers. Use code and/or
queries
to add invoice numbers to your existing records and then filter your
report
based on the existing invoice numbers.

--
Duane Hookom
MS Access MVP


"Sheryl" wrote in message
...
I need to add an Invoice (AutoNumber) to a report. How do I do
this so
that the number will automatically insert itself into the report
already
sorted and grouped? And if needed the report can be searched based
on that
Invoice Number?

Duane,

You are correct, I did not mention the "Bill To" factor before. Thank you for your help.

----- Duane Hookom wrote: -----

I missed any mention of "Bill To" in your previous message. My solution was
to use code or some other method to create your invoice numbers and store
them in a table. Then just run the report with the invoice numbers already
calculated.

--
Duane Hookom
MS Access MVP
--

"Sheryl" wrote in message
...
That works out well if you are sorting by Invoice numbers. I have to sort
by "Bill To" numbers. There are multiple stores using one "Bill To" number
though they are located all over Texas, it would be chaotic to bill each
store individually to the "BIll To" number, as well as a waste of a good
tree.
----- Duane Hookom wrote: -----
I would never use reports to create Invoice numbers. Use code and/or
queries
to add invoice numbers to your existing records and then filter your
report
based on the existing invoice numbers.
--
Duane Hookom
MS Access MVP
"Sheryl" wrote in message
...
I need to add an Invoice (AutoNumber) to a report. How do I do
this so
that the number will automatically insert itself into the report
already
sorted and grouped? And if needed the report can be searched based
on that
Invoice Number?