Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Left$, Left, Mid, Right, Right$
Terry, You were absolutely right: there was a missing reference to some sort of a help file that was checked. Even though it had nothing to do with the error message about not finding the 'LEFT' I unchecked it. That fixed the problem. Many thanks for your help. Dawn, Hope you find a way to...- Norm158
- Post #14
- Forum: Microsoft: Access Other topics
-
Left$, Left, Mid, Right, Right$
Terry, Thanks a lot for your responses, but I'm afraid I'm still at sea: I did do as DougP suggested: All the libraries he mentioned were already checked. The artilce you suggested I read said that after getting an error message, there would be an entry "MISSING: <referencename> in the...- Norm158
- Post #11
- Forum: Microsoft: Access Other topics
-
Left$, Left, Mid, Right, Right$
Im an Access Newbie. I'm trying to create a calculated field "ZIPprefix" which consists of the first three digits of another field, "ZIP", which contains user entered zip codes. In query design view, I've defined a query field as follows: ZIPprefix: LEFT([ZIP],3) When I...- Norm158
- Post #3
- Forum: Microsoft: Access Other topics
