Solved

group in access cross column

Posted on 2013-05-19
4
365 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 119

Accepted Solution

by:
Rey Obrero 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 119

Expert Comment

by:Rey Obrero
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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…

947 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now