Access date to Excel serial number 2

[swtrader]

I need to concat a string from a date, a number and a number with result = 39465-1-3, 39465-1-5, 39484-1-3, etc. And then group and sum by each unique value. Then export to Excel into a lookup table.

I've searched and searched but don't find an easy way to convert an Access date into an Excel equivalent Serial Number.

thanks.

swtrader

 

[PHV]

What about something like CLng([Date field]) ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[swtrader]

Worked like a charm.

Thanks!

swtrader
-- If you don't know where you're going, you'll always know when you're not there.