-
Oct 19th, 2012, 03:22 PM
#1
Thread Starter
Frenzied Member
no idea how to phrase this query
OK, I have a simple table of unique word parts like this:
Part
===
cal
ifo
rnia
wha
tev
er
ca
lif
or
nia
Now what I need to be able to do is send a query to that will tell men how many combinations can form a given word
For example, if I said how many ways are there to spell out 'whatever' from the records in field 'Part', I would get a count of 1, but if i asked about the word 'california', then the count would be 2.
Any ideas?
Like some kind of Cast() where I concatenate the field 'Part' to itself, or maybe it requires a UDF?
Thanks.
I'ts Access if that helps.
Wen Gang, Programmer
VB6, QB, HTML, ASP, VBScript, Visual C++, Java
-
Oct 19th, 2012, 03:51 PM
#2
Thread Starter
Frenzied Member
Re: no idea how to phrase this query
Never mind.
I was seriously overthinking it.
Faster to work this out in code than in the query.
Thanks all.
Wen Gang, Programmer
VB6, QB, HTML, ASP, VBScript, Visual C++, Java
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|