Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

group in access cross column

Posted on 2013-05-19
4
394 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 40

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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

856 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