AutoNumber

[Sheryl]

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 Hookom]

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

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?

 

[Sheryl]

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 querie
to add invoice numbers to your existing records and then filter your repor
based on the existing invoice numbers

--
Duane Hooko
MS Access MV

I need to add an Invoice (AutoNumber) to a report. How do I do this s

that the number will automatically insert itself into the report alread
sorted and grouped? And if needed the report can be searched based on tha
Invoice Number

 

[Duane Hookom]

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
--

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.

 

[Sheryl]

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 wa
to use code or some other method to create your invoice numbers and stor
them in a table. Then just run the report with the invoice numbers alread
calculated

--
Duane Hooko
MS Access MV
-

That works out well if you are sorting by Invoice numbers. I have to sor

by "Bill To" numbers. There are multiple stores using one "Bill To" numbe
though they are located all over Texas, it would be chaotic to bill eac
store individually to the "BIll To" number, as well as a waste of a goo
tree