How to format a number (combination of today's date and VendorID)

  • Thread starter Thread starter Vance
  • Start date Start date
V

Vance

I need to create a number that will be used in the Purchase Order ID
field. I would really like for the new number to be a combination of
the current date and the VendorID, but I can't figure out how to do
it.

I have tried:

CLng([Date()] & [fldVendorID])

but this isn't working; I get a conversion error.

Does anyone know how to do this?

Thanks,
Everette
 
Thanks very much!!!

Everette

Ken Snell said:
CLng(Format(Date(), "mmddyyyy") & [fldVendorID])


--
Ken Snell
<MS ACCESS MVP>

Vance said:
I need to create a number that will be used in the Purchase Order ID
field. I would really like for the new number to be a combination of
the current date and the VendorID, but I can't figure out how to do
it.

I have tried:

CLng([Date()] & [fldVendorID])

but this isn't working; I get a conversion error.

Does anyone know how to do this?

Thanks,
Everette
Click to expand...
Click to expand...
 
Back
Top