|
View Full Version : Name and Address in same textbox bobsyeruncle 08-10-2010, 11:52 AM How can i display Name and address in the same box on my report? They are stored in two seperate fields in the table. The box has a border so i cant just sit a 'name' textbox on top of the address one. I am assuming i am being pretty thick! PNGBill 08-10-2010, 11:58 AM How can i display Name and address in the same box on my report? They are stored in two seperate fields in the table. The box has a border so i cant just sit a 'name' textbox on top of the address one. I am assuming i am being pretty thick! You can concatenate the data. This can be done by sql, by DLookup and a few more. I have just done one where few labels are used because I concatenated the label with the data. Don't do this with data you later want to use with other calculated controls. DLookup("[fieldname1]&" "&[fieldname2]","Sourcetable or SQL","Criteria if used") Kryst51 08-10-2010, 11:59 AM Is the report based on a query? If so you can concatenate the two fields in the query under an alias, then use the alias on your report instead. Concatenation (http://www.techonthenet.com/access/queries/concatenate.php) |