H
hcs
hello,
i have a field called "lastinv" in table "status". What i would like is to
create an append query which looks at this field and keeps adding one to the
invoice num in the invoice table. so for example if 7 invoices were going to
be created then the first invoice num would be lastinv+1, next lastinv+2
etc. At present i do not undetstand how to do this using an access query. i
can figure it out using vb code but i would rather not use vb if a query can
be created and add 1 to the invoicenum for each added invoice.
When an invoice is created it gets its some of its information from the
"customer" table. For example moving customer address details into the
invoice table. what i would like to do is to just use an append query to
populate the invoice table and use
Please help!!!!
Cheers
i have a field called "lastinv" in table "status". What i would like is to
create an append query which looks at this field and keeps adding one to the
invoice num in the invoice table. so for example if 7 invoices were going to
be created then the first invoice num would be lastinv+1, next lastinv+2
etc. At present i do not undetstand how to do this using an access query. i
can figure it out using vb code but i would rather not use vb if a query can
be created and add 1 to the invoicenum for each added invoice.
When an invoice is created it gets its some of its information from the
"customer" table. For example moving customer address details into the
invoice table. what i would like to do is to just use an append query to
populate the invoice table and use
Please help!!!!
Cheers