How do you join two columns in a query for Microsoft Access?
-
Here's an example: I have to make a query with a member list showing the Member ID, Member Type, and Company sorted by Company wihtin Member Type.
-
Answer:
You can try doing a union SQL formula. This is an example, but check out MS Office web site. SELECT [Field1],[Field2],[Field3] FROM [BAXSaver Canada] UNION ALL SELECT [Field1],[Field2],[Field3] FROM [BAXSaver Hawaii] UNION ALL SELECT [Field1],[Field2],[Field3] FROM [BAXSaver US] ORDER BY [Field1], [Field2];
sja82105 at Yahoo! Answers Visit the source
Other answers
try adding another column that looks something like this: MType_C: [Member Type] & ' ' & [Company]
MK6
Related Q & A:
- How to convert my SQL query to MS Access query?Best solution by Stack Overflow
- How to enable Microsoft Access Driver (*.mdb, *.accdb) in Microsoft Azure server?Best solution by Stack Overflow
- How to write Join Query for two tables without foreign key in Yii2?Best solution by Stack Overflow
- How can people join Yahoo groups without a Yahoo account?Best solution by answers.yahoo.com
- Is there a free program like Microsoft Access?Best solution by wiki.answers.com
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.