If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
AutoNumber
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? |
#3
|
|||
|
|||
AutoNumber
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? |
#4
|
|||
|
|||
AutoNumber
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? |
Thread Tools | |
Display Modes | |
|
|