June 21st, 2012, 01:35 PM
VBA Split Function?
I'm using VBA in an Access database. I need to split data that looks like this:
1/10/2012 1:14:43 PM1/10/2012 1:14:43 PMLastName, FirstName
I need to split on the PM(or AM) section of this. It doesn't look like there's a Split() function in VBA like there is in VB.NET. Does anyone have any ideas for this?
June 21st, 2012, 01:45 PM
Split() should be available in Access VBA. Check the Access VBA documentation for your version of Access.
Bartender to Rene Descartes "have another beer?" Descartes: "I think not" and he vanished.