M
Mindy
This is my query: SELECT [Contact Info].[First Name], [Contact Info].[Last
Name], [Contact Info].Gender, [Contact Info].Address, [Contact Info].[Address
2], [Contact Info].City, [Contact Info].State, [Contact Info].Zip,
Asbestos.[KY Exp], Asbestos.[IL Exp], Asbestos.[IN Exp], Asbestos.[MI Exp],
Asbestos.[OH Exp], Asbestos.[WI Exp]
FROM [Contact Info] LEFT JOIN Asbestos ON [Contact Info].ID = Asbestos.ID
WHERE (((Asbestos.[KY Exp])<#6/27/2008#)) OR (((Asbestos.[IL
Exp])<#6/27/2008#)) OR (((Asbestos.[IN Exp])<#6/27/2008#)) OR (((Asbestos.[MI
Exp])<#6/27/2008#)) OR (((Asbestos.[OH Exp])<#6/27/2008#)) OR (((Asbestos.[WI
Exp])<#6/27/2008#));
Is there a way I can exlude certifications that are still valid? For
example if the IN cert is expired, but the IL cert is still valid, the IL
expiration date will not show up?
I ask because I want to bring this information into a Publisher Postcard via
Mail Merge.
Thank you so much for your help!
Name], [Contact Info].Gender, [Contact Info].Address, [Contact Info].[Address
2], [Contact Info].City, [Contact Info].State, [Contact Info].Zip,
Asbestos.[KY Exp], Asbestos.[IL Exp], Asbestos.[IN Exp], Asbestos.[MI Exp],
Asbestos.[OH Exp], Asbestos.[WI Exp]
FROM [Contact Info] LEFT JOIN Asbestos ON [Contact Info].ID = Asbestos.ID
WHERE (((Asbestos.[KY Exp])<#6/27/2008#)) OR (((Asbestos.[IL
Exp])<#6/27/2008#)) OR (((Asbestos.[IN Exp])<#6/27/2008#)) OR (((Asbestos.[MI
Exp])<#6/27/2008#)) OR (((Asbestos.[OH Exp])<#6/27/2008#)) OR (((Asbestos.[WI
Exp])<#6/27/2008#));
Is there a way I can exlude certifications that are still valid? For
example if the IN cert is expired, but the IL cert is still valid, the IL
expiration date will not show up?
I ask because I want to bring this information into a Publisher Postcard via
Mail Merge.
Thank you so much for your help!