C
Chris Mitchell
Using MS Access 2003.
I have a database that contains among other things a query that finds 'short
numbers', (numbers that are only 5 digits long, e.g. XXXXX) from another
table that contains predominately 6 digit numbers. This query finds 17
short numbers.
I have another table that shows valid expansions for the short numbers. The
short numbers are always the first 5 digits of the permitted expansions
(e.g. XXXXX1, XXXXX2 etc) and each short number can have several valid
expansions (max 10 - obviously) in the list of valid expansions. The valid
expansion table contains 106 records.
I only want to know if a short number is found by the query that doesn't
have at least one valid expansion.
I presume this would use the 'Find Unmatched Query Wizard', but don't know
what the criteria would be to only show short numbers that do not have at
least one valid expansion. Any suggestions?
I'm a novice at this so step by step instructions would be appreciated.
TIA.
Chris.
I have a database that contains among other things a query that finds 'short
numbers', (numbers that are only 5 digits long, e.g. XXXXX) from another
table that contains predominately 6 digit numbers. This query finds 17
short numbers.
I have another table that shows valid expansions for the short numbers. The
short numbers are always the first 5 digits of the permitted expansions
(e.g. XXXXX1, XXXXX2 etc) and each short number can have several valid
expansions (max 10 - obviously) in the list of valid expansions. The valid
expansion table contains 106 records.
I only want to know if a short number is found by the query that doesn't
have at least one valid expansion.
I presume this would use the 'Find Unmatched Query Wizard', but don't know
what the criteria would be to only show short numbers that do not have at
least one valid expansion. Any suggestions?
I'm a novice at this so step by step instructions would be appreciated.
TIA.
Chris.