need to merge two access 2003 cells with info into one cell

July 25, 2012 at 22:37:45
Specs: Windows XP
how do i merge two rows both have info want to make it into one cell for ex. one has street number like 123 and second cell row has street name like Byers rd. i want to put it into one cell all info. It should read in one cell 123 Byers Rd.

See More: need to merge two access 2003 cells with info into one cell

Report •

#1
July 25, 2012 at 23:33:49
I've never used it in Access though I know it can be done as a similar function is available in Excel, but what you are trying to do is called 'concatenating' and is a standard function in spreadsheet/database programs. Someone will probably come along with a step-by-step guide, but if not, do a Google for concatenating in access and choose one of the many walkthroughs available.

"I've always been mad, I know I've been mad, like the most of us..." Pink Floyd


Report •
Related Solutions


Ask Question