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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: sweetkel23
- Content: Threads
- Order by date
-
MS Access concatenate and trim
I'm trying to concatenate an address with trim. I need to determine whether or not ST_DIR1 and ST_SUFFIX exist. If they do not exist, then I want the ST_NAME1 and SUITE to display if any, else the entire address (concatenated with spaces in between and no leading or trailing spaces) ConcAddr...- sweetkel23
- Thread
- Replies: 7
- Forum: Microsoft: Access Other topics
