Results 1 to 7 of 7
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Query issues (2007)

    I cant help cause i dont have 2007

  2. #2
    Star Lounger
    Join Date
    Dec 2007
    Posts
    98
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query issues (2007)

    Thank you. It was the thought that count

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

    Re: Query issues (2007)

    If you save your database in Access 2000 format and zip it, you might have a better chance of getting a reply. The number of Access 2007 users is still limited.

  4. #4
    Star Lounger
    Join Date
    Dec 2007
    Posts
    98
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query issues (2003)

    I have this posting in Excel but it was giving me too much of a headache. One of the contributors suggested that I use Access so I'm kinda stuck. I have 3 tables: the Insert_abc, abc_Phonelist, and the Processors. This query is to reference the ACCT from the Insert_abc table and find the “best” contact information based on the following. If the ACCT does not have a Parent then you reference the ACCT to the abc_Phonelist table. If the ACCT does have a Parent then use the Parent ACCT since it has a more desirable account number to reference against the abc_Phonelist. If the ACCT or the Parent ACCT uses Processors then the ACCT from the Processors sheet has the best reliable account number to reference against the abc_Phonelist. Also, the ACCT needs to be 9 digits in length so it might needs to be normalized.
    In sum, there are three different possible “number tiers” that can be used.
    The first, the ACCT phone number. This means that the ACCT has neither a Parent nor a Processor.
    The second, the parent ACCT phone number. This means that the ACCT has a Parent, but neither the Parent ACCT nor the ACCT has a Processor.
    The third, the Processor phone number. This means that either the ACCT or the Parent ACCT has a Processor phone number.
    Any assistance will be greatly appreciated.
    Attached Files Attached Files

  5. #5
    Star Lounger
    Join Date
    Dec 2007
    Posts
    98
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query issues (2007)

    Thank you for the FYI.

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

    Re: Query issues (2007)

    The format of the field containing the "client of" was not suitable for use in calculations - I've split it into two separate fields - ACCT and ClientOf.
    You can then use a series of queries to obtain your goal, if I understand it correctly.
    See the attached version.
    Attached Files Attached Files

  7. #7
    Star Lounger
    Join Date
    Dec 2007
    Posts
    98
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query issues (2007)

    Thank you..you're awesome! <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>

Posting Permissions

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