Recent content by Laurel92

Thanks Remou, that did it.

The whole thing was built with the query designer including the first zip. When I try adding a second zip to equal a [Org_Postal_Cd_Txt] that is when I get no records.

I must have copied the wrong query, here it is. SELECT tbl_Org_Name.Name, tbl_Org_Address.Org_Address_txt, tbl_Org_City.Org_City_Txt, tbl_Org_Address.Org_Phone_txt, tbl_Org_Address.Org_Fax_txt, tbl_Sol_Prefix.Solicitor_prefx_txt, [Solicitor] AS Expr1, tbl_Solicitor.Sol_First_txt FROM...

Here is the code that works (Adds 1 person to any org within 1 zip code. What I want is to be able to do the same thing with 1 OR more zip codes. My code for adding a second zip doesn't work either. (even if zips match) SELECT tbl_Org_Name.Name, tbl_Org_Address.Org_Address_txt...

SELECT tbl_Org_Name.Name, tbl_Org_Address.Org_Address_txt, tbl_Org_City.Org_City_Txt, tbl_Org_Address.Org_Phone_txt, tbl_Org_Address.Org_Fax_txt, tbl_Solicitor.Sol_First_txt, [Zip2] AS Expr2, [Zip3] AS Expr3 FROM tbl_Org_Name INNER JOIN (tbl_Org_Address INNER JOIN tbl_Org_City ON...

I want to make a query which accepts 1 to 3 zip codes as input, zip2 and zip3 I want to be able to leave blank. Currently it gives me an empty report. Can someone HELP?? please. T