MS Access query don't show first 22 characters

MS Access query needs to show all data after the first 22 characters. First part of the field is a date/time combination. Need to just show data after that to be able to group.
   02.05.18 09:42:01  USMC Mock Rd 115  PROBE STATUS PHC     PPC ...                  Normal
dgravittAsked:
Who is Participating?
 
Fabrice LambertFabrice LambertCommented:
Hi,

Would Something like the following work ?
SELECT Mid([yourData], 23) As yourField
FROM yourTable;

Open in new window

0
 
dgravittAuthor Commented:
Thanks, works great
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.