Access Student
- Thread starter adnmhz
- Start date
- Local time
- Yesterday, 21:42
- Joined
- Feb 28, 2001
- Messages
- 30,284
Welcome.
In the main Access topics section, ask your questions. Advice? Ask clearly what you want to know or tell us clearly what you want to do. I say that because it will be your project and YOU have the image of your goals in your head. We will need to know as well so that our advice can be targeted.
However, having said that, any techie question is ABSOLUTELY fair game. So... ask away!
In the main Access topics section, ask your questions. Advice? Ask clearly what you want to know or tell us clearly what you want to do. I say that because it will be your project and YOU have the image of your goals in your head. We will need to know as well so that our advice can be targeted.
However, having said that, any techie question is ABSOLUTELY fair game. So... ask away!
As your intro starts with Access Student, please let us know if a question is related to a school assignment. If it is, please be very clear on what the assignment calls for.
What answer you get depends on how you phrase the question AND if we know if it is for an assignment instead of for a live database.
What answer you get depends on how you phrase the question AND if we know if it is for an assignment instead of for a live database.
I just introduced myself as student of access......mean I am not a professional of access database but in learning stage.............I am making an access database in my office.........i have various customers in my customer table...I want an auto increment invoice number with prefix (text) for each customer when I create new invoice..........so that on creating new invoice i will have new invoice number every time. Please help me as I dont have idea how to solve this query.
You will want to first do a search for your question (Search V up above) as this comes up often. If none of the returns provide you a good answer or one that will work for you then please start a new thread.
In general, most developers will have an autonumber primary key for their table. When they need to put up a "Human readable" invoice number they simply use part or all of their primary key but put something in front, such as a month, for display and printing.
In general, most developers will have an autonumber primary key for their table. When they need to put up a "Human readable" invoice number they simply use part or all of their primary key but put something in front, such as a month, for display and printing.
