Parentheses Problem

[kbreiss]

The following query works, I'm just wanting to add a date parameter (below)...When I add the data parameter it seems to ignore that criteria.

I just want to add this:
Event_Date Between [Enter Start Date mm/dd/yyyy] And [Enter End Date mm/dd/yyyy]


WHERE (((tblContacts_Speakers.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_1.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_1.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_2.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_2.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_3.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_3.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_4.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_4.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_5.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_5.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_6.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_6.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_7.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_7.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_8.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_8.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_9.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_9.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname]));
________
HotGirlCeleste

 

[Ian Mac]

......t_Name]![txtLname])) AND (Event_Date Between [Enter Start Date mm/dd/yyyy] And [Enter End Date mm/dd/yyyy]);

You should also look at the rest of the ()'s as Access isn't good at second guessing

For example:

WHERE (((tblContacts_Speakers.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname])

certainly aren't need.

Make it easier for you to read.