Combining 3 columns into one in a access query

Posted by Kath on Super User See other posts from Super User or by Kath
Published on 2010-03-30T22:48:48Z Indexed on 2010/03/30 22:53 UTC
Read the original article Hit count: 219

Filed under:

microsoft-access-2007

I have inserted a column into design view of my query. How do I combine three separate columns into one. I need to get the City, State and Zip into my new column?

Related posts about microsoft-access-2007

Microsoft Access 2007 Certification

as seen on Internet.com - Search for 'Internet.com'
Certification doesn't make one an IT super hero but it's something every developer should consider. Some might argue that there aren't any certifications for Microsoft Access application developers and they would be correct, however, the Microsoft Access 2007 Application Specialist (MCAS) exam might… >>> More
Is there a way to restrict direct write access to the DB in Microsoft Access 2007?

as seen on Super User - Search for 'Super User'
I'd like to set up an Access (2007) project that contains queries on a DB (actually in MS SQL Server 2005), but I do not want to allow any direct writing to the DB. (Basically, just read-only.) Is this possible? Thanks in advance! >>> More
Microsoft Access 2007 books

as seen on Super User - Search for 'Super User'
I would like to ask your suggestions, if you know any good books for Microsoft Access 2007, including the migration from old versions to new versions. >>> More
Microsoft Access 2007: Export to multiple xml files

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a table in my access database and I want to export each record to a single xml file. How can I achieve this?The only option I found was exporting the whole table to a single xml file. >>> More
Help with Ms Access 2007 Combo boxes

as seen on Super User - Search for 'Super User'
What's the most efficient way to "chain" combo/boxes in an Access 2007 form, so that the result of the first affected the contents of the second? I already know how to associate a combo box on a form with a query. Here's a example of my scenario: cmbCarMake Behavior: User starts typing, and list… >>> More

Developer IT

Combining 3 columns into one in a access query - Developer IT

Combining 3 columns into one in a access query

microsoft-access-2007

Related posts about microsoft-access-2007

Microsoft Access 2007 Certification

Is there a way to restrict direct write access to the DB in Microsoft Access 2007?

Microsoft Access 2007 books

Microsoft Access 2007: Export to multiple xml files

Help with Ms Access 2007 Combo boxes

Categories cloud