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 strongm 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: UncleBonehead
- Order by date
-
Concatenate, IsNull, Carriage Return
Duane, Issue #1 was resolved by using your suggestion, thank you... Component Info: Concatenate("SELECT [Issue#] + ') ' & [PartName] & '; P/N: ' + [PartNbr] & '; TOW: ' + [PartTOW] & IIf(IsNull([PartUnsRemTY]),'', Chr(13) & Chr(10) & 'UNS RMVLS:' & Chr(13) & Chr(10) & " & Year([ExDate]) & " &...- UncleBonehead
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Concatenate, IsNull, Carriage Return
1) How can I prevent the following from creating the extra line returns if the [PartComments] field is null? 2) How can I prevent the following from creating the extra line returns at the end if there is only one record? Component Info: Concatenate("SELECT [Issue#] + ') ' & [PartName] & '; P/N...- UncleBonehead
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
