Microsoft Access 2003 queries

[Kimberly@FG]

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.

 

[Jerry Whittle]

SELECT [Postal Code].PostalCode,
[Postal Code].HealthDept,
[Postal Code].State,
[Postal Code].County
FROM [Postal Code], Member
WHERE [Postal Code].PostalCode = Left([Member]![Postalcode],5) ;