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.
It is a truism of American politics that no man who can win an election deserves to. --Trevanian, from the novel Shibumi