Solved

group in access cross column

Posted on 2013-05-19
4
400 Views
Last Modified: 2013-06-04
I have attached a spreadsheet to demonstrate.

I need to filter on words I wont know yet because they are contained across columns and down rows.

how might i do that?

ultimately those words will go in a dropdown or list so that they can be filtered.
example.xlsx
0
Comment
Question by:PeterBaileyUk
  • 2
4 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 250 total points
ID: 39178519
using a union query

select Distinct Word1 as [Word]
from tableX
where Word1 is not null
union
select Distinct Word2 as [Word]
from tableX
where Word2 is not null
union
etc...
0
 
LVL 41

Assisted Solution

by:Sharath
Sharath earned 250 total points
ID: 39178648
With UNION, unique values are returned. No need of DISTINCT in capricorn1 solution.
select Word1 as [Word]
from tableX
where Word1 is not null
union 
select Word2 as [Word]
from tableX
where Word2 is not null
union
etc...

Open in new window

0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39179345
yes that is correct,
0
 

Author Closing Comment

by:PeterBaileyUk
ID: 39219588
sorry for delay tomorrow i have an operation so mind was not on  work.
0

Featured Post

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS Access 2013 field type short text default value 5 24
Syntax issue with my Where Clause SQL 2012 20 38
SQL Pivot table 2 42
Access #Deleted data 20 34
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question