M
Matt P
Hello, I have a form that has four check boxes and all of them work
fine except for the last one which is to not exclude anything. Here is
my sql:
SELECT tblCompanies.[Company Name],
tblCompanies.State,
tblCompanies.City,
tblCompanies.Show,
tblCompanies.Independent,
tblAdjusters.Save,
tblAdjusters.Address,
tblAdjusters.ZipCode,
tblAdjusters.[Last Name],
tblAdjusters.[First Name]
FROM tblCompanies INNER JOIN tblAdjusters
ON tblCompanies.ID = tblAdjusters.CompanyNumber
WHERE (((tblCompanies.State)=IIf([FORMS]![frmMailingList]!
[chkMN],"MN"))) OR (((tblCompanies.State)=IIf([FORMS]![frmMailingList]!
[chkWI],"WI"))) OR (((tblCompanies.State)=IIf([FORMS]![frmMailingList]!
[chkIL],"IL"))) OR (((tblCompanies.State)=IIf([FORMS]![frmMailingList]!
[chkAll],([tblCompanies].[State]) Like "*")));
Not sure what the syntax of the last one should be...
Thanks!
Matt P
fine except for the last one which is to not exclude anything. Here is
my sql:
SELECT tblCompanies.[Company Name],
tblCompanies.State,
tblCompanies.City,
tblCompanies.Show,
tblCompanies.Independent,
tblAdjusters.Save,
tblAdjusters.Address,
tblAdjusters.ZipCode,
tblAdjusters.[Last Name],
tblAdjusters.[First Name]
FROM tblCompanies INNER JOIN tblAdjusters
ON tblCompanies.ID = tblAdjusters.CompanyNumber
WHERE (((tblCompanies.State)=IIf([FORMS]![frmMailingList]!
[chkMN],"MN"))) OR (((tblCompanies.State)=IIf([FORMS]![frmMailingList]!
[chkWI],"WI"))) OR (((tblCompanies.State)=IIf([FORMS]![frmMailingList]!
[chkIL],"IL"))) OR (((tblCompanies.State)=IIf([FORMS]![frmMailingList]!
[chkAll],([tblCompanies].[State]) Like "*")));
Not sure what the syntax of the last one should be...
Thanks!
Matt P