troubleshooting Question

Having problems with SQL statement on spliting a cell in Access

Avatar of u2babs
u2babs asked on
Microsoft AccessSQL
11 Comments2 Solutions335 ViewsLast Modified:
I have a cell that populates from a linked SharPoint multislect field. In a Query I am tryin gto filter it so that I can group and sort in a report on each different Value in the cell.

For example:
The cell looks like
12/23/09#;12/24/09#;

I received a solution a week ago:
looks like yes...

select id, holidayDate frorm (
select id, splitNget(holiday, ";", 0) as holidayDate from tblholidays
union
select id, splitNget(holiday, ";", 1) from tblholidays
...
union
select id, splitNget(holiday, ";", 20) from tblholidays
) as x order by holidaydate, id

it will give you

11/27/09 Record 1
11/27/09 Record 2
11/27/09 Record 3
11/28/09 Record 1
11/28/09 Record 2
11/28/09 Record 3

But I have no idea where and how to add this. Do I use this in the report? do I use this in a Query and if I use it in a query do I add it a in teh crieria line.  I know this must be simple, but for some reason I can't get my heda around where to use this SQL statement.  I need to have this solved to produce a report for next week that will group and sort records based on the cell produced by teh Sharepiont multiselect field that doesn't group the report like
 #;12/22/09#12/23/09;#
 #;12/22/09#12/23/09;#12/24/09
ASKER CERTIFIED SOLUTION
MikeToole

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 11 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros