Good afternoon, all, as an Access Novice I apologise if I dont word this question correctly, however I am having a problem combining parts of an address into one field on a Report.
In a table I have the following fields: Company Name; Address1, Address2, Town, Post Code. When I 'concatenate; Town and Post Code, i.e.
[Town] & " " & [Post Code]
it works perfectly, but when I try
[Address1] & " " & [Address2] I get the error <div> or try to add Address1 to the bit that does work. Id really like to put all parts of the Address into one on the report
Any ideas? Im sure its a very simple problem just cant seem to work it out.
Thank you
In a table I have the following fields: Company Name; Address1, Address2, Town, Post Code. When I 'concatenate; Town and Post Code, i.e.
[Town] & " " & [Post Code]
it works perfectly, but when I try
[Address1] & " " & [Address2] I get the error <div> or try to add Address1 to the bit that does work. Id really like to put all parts of the Address into one on the report
Any ideas? Im sure its a very simple problem just cant seem to work it out.
Thank you
