Results 1 to 11 of 11
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Compiling multiple fields (Access 2000 SR1)

    I need to develop a database that assembles a complete item description based on the input of ten different fields. Please see the attachment which outlines an example.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Compiling multiple fields (Access 2000 SR1)

    Why do you have both a grouping order field (F1) AND separate fields for the grouping levels? One or the other seems superfluous.

  3. #3
    Star Lounger
    Join Date
    Feb 2001
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compiling multiple fields (Access 2000 SR1)

    Field F1 represents the order in which the fields F2-F10 need to be listed (i.e. the segment of the complete item number). F2 represents the group type, the example only lists one group but there are dozens. I'm definetly open to suggestions if there is an easier method.

    Any assistance or guidance is appreciated.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Compiling multiple fields (Access 2000 SR1)

    The order suggested by the values in F1 is the same as the order of the fields F3-F10 in your example (F1 = 1 corresponds to F3/F4, F1 = 2 to F5, F1= 3 to F6, F1 = 4 to F7, F1 = 5 to F8 and F1 = 6 to F9/F10). Could it be otherwise for other examples?

  5. #5
    Star Lounger
    Join Date
    Feb 2001
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compiling multiple fields (Access 2000 SR1)

    Unfortunately it is different for other examples. I could send you the table if you like.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Compiling multiple fields (Access 2000 SR1)

    If you could post a more complete sample, that would be useful.

  7. #7
    Star Lounger
    Join Date
    Feb 2001
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compiling multiple fields (Access 2000 SR1)

    Here is the table. Again, any assistance is appreciated.

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Compiling multiple fields (Access 2000 SR1)

    <img src=/S/yikes.gif border=0 alt=yikes width=15 height=15> Couldn't they have thought of a more logical setup? Is this the complete table, or are still other patterns possible now or in the future?

  9. #9
    Star Lounger
    Join Date
    Feb 2001
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compiling multiple fields (Access 2000 SR1)

    This should be a complete listing .... but who knows what they will come up with in the future .. it's driving me crazy <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Compiling multiple fields (Access 2000 SR1)

    I have attached your database with three queries added to it that I hope will do what you want.

    qryCharacters divides the input value into individual characters.
    qryParts computes each of the seven parts of the description.
    qryDescription assembles the complete description.

    I analyzed all patterns present in the current table, for example part 6 is determined by the combination of F2, F9, F10 and F11 OR by the combination of F2, F10 and F11 (with F9 blank) OR by the combination of F2, F8 and F9. Let's hope that there won't be other such patterns.

    Note: the original example in your Word document was not compatible with the actual table.

  11. #11
    Star Lounger
    Join Date
    Feb 2001
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compiling multiple fields (Access 2000 SR1)

    This is exactly what is needed. Thank you very much!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •