I am creating an invoice report, but want to enter in an auto number for an invoice number. So that all invoices i create have a unique invoice number on it!
2007-02-21 23:37:00 · 3 answers · asked by Cap10kirk 3 in Computers & Internet ➔ Software
You need an autonumber field in the table you are creating the report from and a query to get the data from it.
2007-02-21 23:46:34 · answer #1 · answered by Del Piero 10 7 · 0⤊ 0⤋
I think it's called the primary key. When you set up a database using the wizrd, it gives you the option of setting the primary key. I haven't used it for ages so I can't remember how to do it if your database already exists. Try the 'help' feature.
2007-02-23 06:17:01 · answer #2 · answered by the southern dandy 3 · 0⤊ 0⤋
I think it's called the primary key. When you set up a database using the wizrd, it gives you the option of setting the primary key. I haven't used it for ages so I can't remember how to do it if your database already exists. Try the 'help' feature.
2007-02-22 07:47:59 · answer #3 · answered by finch 5 · 0⤊ 0⤋