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!
Bookmarks