Invoice Number

[sparker2]

Hello everyone! I need help. I am trying to add an invoice number to my invoice report that will change every time I open up a new order and get ready to print the invoice for my customers. I am new at this so I am having a real hard time understanding what I need to do. I would like my invoice to start with a number like 00116992 or something like that. What is the easiest way to do this? If you can help please email me at sparker2@cox.net

Thanks so much for your help.

 

[JustMaybe]

Hi sparker

I ahev got exactly the same problem, and have been trying to resolve it for overa month...someone else has found my problem on another forum and asked this same question

If you have any solutions please let me know!!!

I had quite a lot of help from col (colinessex) but i now realised its not the same track!!!

 

[Pat Hartman]

If you want to start an autonumber at a specific number, create an append query that appends a row to the table containing a value for the autonumber that is 1 less than where you want it to start. To do this, create a new append query and type a literal value into the Field cell for each column that requires data. Your query will look something like:

INSERT INTO tblFieldTypeCodes ( TypeCode, TypeDesc )
SELECT 116992 AS Expr1, "Desc" AS Expr2;

 

[JustMaybe]

Hi thank you for replying.

I'm not really sure of how to implement all of that!!

apend query?

where would the query be activated...? on click?

the problem would then be..if there was a problem with a invoice, and it had to be re-printed...then it would have two numbers!?

someone suggested having to create another table??

Sarah

 

[Pat Hartman]

The invoice number is actually an autonumber. I told you how to get the autonumber to start at a particular value.

Have you considered using the order number as the invoice number?

 

[sparker2]

Order

Ok guys, I fixed my problem with my order form. There was a problem with my query. I had put something in there twice and it made duplicate orders for each customer order I entered. Thanks everyone for all your help.

 

[sparker2]

Order form problem

Ok guys, I fixed my problem with my order form. There was a problem with my query. I had put something in there twice and it made duplicate orders for each customer order I entered. Thanks everyone for all your help.

Shareen
sparker2@cox.net