Between [Start Date] And [End Date] and =[True or False].
What is field is True or False? There has to be a field name associated with the [True or False].
Looking at part of the criteria, you would have
Code:
WHERE [HireDate] Between [Start Date] And [End Date]
when you execute the query, you get prompts for the start date and end date. [Start Date] is So the criteria becomes
Code:
WHERE [HireDate] Between #1/1/2011# And #12/31/2011#
You need the criteria to be something like
Code:
WHERE [HireDate] Between [Start Date] And [End Date] AND Check1 = [True or False]
Because there are no fields/controls named [Start Date], [End Date] or [True or False], you get a prompt to enter the criteria values.
Hope this makes sense....