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!
-
Stripping Characters from a Field when building a Query
Thanks for the input and sorry for the delay in responding. It's been a bit busy on this end... I have run into a snag and I don't know whether it's something I am doing or not. (Remember, I said I was very new at this Access stuff) When I attempt to either type in or cut-n-paste the routine...- DrMack
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Stripping Characters from a Field when building a Query
I am trying to build a query out of two tables from two different databases. Each has a common reference id. My only problem is that the contents of the two fields, are different. One of them contains the following format: last_name, first_name first_initial. The other is as follows...- DrMack
- Thread
- Replies: 6
- Forum: Microsoft: Access Queries and JET SQL
