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!
Recent content by sweetkel23
-
MS Access concatenate and trim
You were right, the query worked in a new database. Thanks for helping me realize my query was corrupted, probably since I made a lot of changes. Thank you so much!- sweetkel23
- Post #8
- Forum: Microsoft: Access Other topics
-
MS Access concatenate and trim
I added the SUITE as shown below but getting "undefined function 'trim' in expession: ConcatAdd: [ST_DIR1]+" " & Trim([ST_NAME1]) & " "+[ST_Suffix] & " "+[SUITE]- sweetkel23
- Post #5
- Forum: Microsoft: Access Other topics
-
MS Access concatenate and trim
Thank you MAJP, you've just saved me! You're a gem! Thank you soooo much!!!!! [thumbsup2]- sweetkel23
- Post #4
- Forum: Microsoft: Access Other topics
-
MS Access concatenate and trim
I'm sorry, here is the string I used in my query to create the new concatenated address field: ConcAddr: IIf(Nz([ST_DIR1],"", [ST_DIR1], " ")) & Trim([ST_NAME1]) & " " & IIf(Nz([ST_SUFFIX],"", [ST_SUFFIX], " ")) & Trim[SUITE]- sweetkel23
- Post #2
- Forum: Microsoft: Access Other topics
-
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
