Query issues (2003)

[patt]

I cant help cause i dont have 2007

[Wordnewby65]

Thank you. It was the thought that count

[HansV]

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.

[Wordnewby65]

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.

[Wordnewby65]

Thank you for the FYI.

[HansV]

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.

[Wordnewby65]

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