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

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

select id, holidayDate frorm (
select id, splitNget(holiday, ";", 0) as holidayDate from tblholidays
select id, splitNget(holiday, ";", 1) from tblholidays
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

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