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

 

[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

 

[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