AutoNumber

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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 said:
I need to add an Invoice (AutoNumber) to a report. How do I do this so
Click to expand...
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 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


Sheryl said:
I need to add an Invoice (AutoNumber) to a report. How do I do this s
Click to expand...
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
 
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 said:
That works out well if you are sorting by Invoice numbers. I have to sort
Click to expand...
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

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
-

Sheryl said:
That works out well if you are sorting by Invoice numbers. I have to sor
Click to expand...
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
 
Back
Top