G
Guest
Please help. I have a Select query based on 2 tables (1) Postal Code Table
(fields = PostalCode; County; State; HealthDept) - with 5 digit postal codes
(64127) and (2) Member table (fields = Name; addresss; city; state;
Postalcode) - with 5 digit AND 9 digit postal codes (64131-2489). I want my
query result to tell me what county/health dept. my member should be sent to
based on the member's postal code. The problem is: The query only gives me
results for the members who have the 5 digit postal codes.
(fields = PostalCode; County; State; HealthDept) - with 5 digit postal codes
(64127) and (2) Member table (fields = Name; addresss; city; state;
Postalcode) - with 5 digit AND 9 digit postal codes (64131-2489). I want my
query result to tell me what county/health dept. my member should be sent to
based on the member's postal code. The problem is: The query only gives me
results for the members who have the 5 digit postal codes.