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.