scotty986
06-30-2009, 02:52 PM
I am trying to setup a parameter query using a start and end date
and also a second field.
The date field is fldServiceFollowupDate and I am using the entry
([tblTaServiceFollowup].[ServiceFollowupDate])>=[StartDate]<[EndDate]
in the Criteria line of the query under fldServiceFollowupDate. I have set the
query parameters for StartDate and EndDate to Date/Time.
In addition, I have a second field for consideration in the query.
fldServiceFollowupCheckbox is a checkbox field. I have entered No in the
Criteria under fldServiceFollowupCheckbox.
However, the query is bringing up all of the records with the Checkbox NO and is not considering the date parameters.
How can I combine the two and achieve the results that I want.
Thanks.
and also a second field.
The date field is fldServiceFollowupDate and I am using the entry
([tblTaServiceFollowup].[ServiceFollowupDate])>=[StartDate]<[EndDate]
in the Criteria line of the query under fldServiceFollowupDate. I have set the
query parameters for StartDate and EndDate to Date/Time.
In addition, I have a second field for consideration in the query.
fldServiceFollowupCheckbox is a checkbox field. I have entered No in the
Criteria under fldServiceFollowupCheckbox.
However, the query is bringing up all of the records with the Checkbox NO and is not considering the date parameters.
How can I combine the two and achieve the results that I want.
Thanks.