Results 1 to 2 of 2

Thread: no idea how to phrase this query

  1. #1

    Thread Starter
    Frenzied Member wengang's Avatar
    Join Date
    Mar 2000
    Location
    Beijing, China
    Posts
    1,602

    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

  2. #2

    Thread Starter
    Frenzied Member wengang's Avatar
    Join Date
    Mar 2000
    Location
    Beijing, China
    Posts
    1,602

    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
  •  



Click Here to Expand Forum to Full Width