Does anyone know how to produce a query which will truncate a particular field based on a character?
IE - the original field may contain "Access*Excel" and I want the new field to contain just "Access"
Another record may contain "Acc*essExcel" and I want it to reflect "Acc"
Thanks in advance for any input!
I am not sure why all of the posts are deleted, however here is what I would do.
Replace "Truncate" with whatever you want the field to be called. I used a "-" instead of an "*". replace it with whatever you want.
Hope this helps,
Please Login or Register to view this content.
Dan
"I am not a rocket scientist, I am a nuclear engineer." - Split_atom18
If my advice has been helpful to you, then please help me by clicking on the "Star" and adding to my reputation, Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks