Hi,
I have an sql query :-
This query basically selects, the add1, add2, add3,add4 fields which holds a persons address sometimes they may not have data in one of the fields.
I would like the data to display the address like:-
Add1
Add2
Add3
Add4
Country
Postcode
but if the fields are null I would like the data to move up a line on the report.
I could concatonate the fields in the query by using the & problem with this is the I would like a CRLF (carrige return) so that each address appears on a new line as it is a letter do you know the best way to go about this. Thanks. Rachel
SELECT tblCourseProvider.CPNO, tblCourseProvider.NameLong, tblCourseProvider.NameShort, tblCourseProvider.StreetNo, tblCourseProvider.Postcode, tblCourseProvider.Add1, tblCourseProvider.Add2, tblCourseProvider.Add3, tblCourseProvider.Add4, tblCourseProvider.Country
FROM tblCourseProvider;
I have an sql query :-
This query basically selects, the add1, add2, add3,add4 fields which holds a persons address sometimes they may not have data in one of the fields.
I would like the data to display the address like:-
Add1
Add2
Add3
Add4
Country
Postcode
but if the fields are null I would like the data to move up a line on the report.
I could concatonate the fields in the query by using the & problem with this is the I would like a CRLF (carrige return) so that each address appears on a new line as it is a letter do you know the best way to go about this. Thanks. Rachel
SELECT tblCourseProvider.CPNO, tblCourseProvider.NameLong, tblCourseProvider.NameShort, tblCourseProvider.StreetNo, tblCourseProvider.Postcode, tblCourseProvider.Add1, tblCourseProvider.Add2, tblCourseProvider.Add3, tblCourseProvider.Add4, tblCourseProvider.Country
FROM tblCourseProvider;