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

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
 
V

Vance

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA word change keys 0
How can the font and size of (all) citation numbers be altered? 1
Wrapping and Anchors 0
How to have two tables on same line? 1
How to add day to PWA 2016 date format? 0
Combine two spreadsheets into one 3
How to Find Record if Exists, Add if not? 7
How To Rapidly Copy Formulas? 0

Top