invoice numbering a report only??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I put invoice numbers that automatically change on a report? I need
to do this because, I invoice customers monthy, for a group of orders created
during the month for thaat one customer, but don't send their invoice until
the end of that month, so the invoice created is a report on the monthy
orders 'booked up' by that customer. I just don't want to number every
single order, just one at the end of the month that will become the tax
invoice number, auto-number preferrably.
thanks
 
Debba said:
How can I put invoice numbers that automatically change on a report?
I need to do this because, I invoice customers monthy, for a group of
orders created during the month for thaat one customer, but don't
send their invoice until the end of that month, so the invoice
created is a report on the monthy orders 'booked up' by that
customer. I just don't want to number every single order, just one
at the end of the month that will become the tax invoice number,
auto-number preferrably.
thanks
Click to expand...

from www.sitocomune.com=
Put in defaultvalue
"E" & Format(Date();"aa") & "/" &
Format(IIf(IsNull(DMax("MioContatore";"MiaTabella";"MioContatore like '?" &
Format(Date();"aa") &
"/????'"));1;Right(DMax("MioContatore";"MiaTabella";"MioContatore like '?" &
Format(Date();"aa") & "/????'");4)+1);"0000")

where "E" is optionalMitabella is your table
Miocontatore is your counter

--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa - Conferenza Italiana per Sviluppatori Access
Info: www.donkarl.com/it
 
Back
Top