Selecting a range of dates for a pivot table

[Peter MacInnsi]

I have two tables, MembersInfo and MemberInfoSubTable. In
the MemberInfo table there is a "Date Of Trial" column. I
want to use this column to select a range of dates to be
displayed in the pivot table. I tried using design view
and putting in the "query to get the information for the
pivot table" but the pivot table query doesn't recognise
my ">=[Enter Start Date] And <=[Enter End Date]" Criteria.
My email is (e-mail address removed).
Thanks in advance.

"Query to get information for pivot table:"

SELECT MemberInfo.Units, MemberInfoSubTable.Article,
Article.Description, MemberInfoSubTable.Finding
FROM MemberInfo INNER JOIN (Article INNER JOIN
MemberInfoSubTable ON Article.Article =
MemberInfoSubTable.Article) ON MemberInfo.MemberID =
MemberInfoSubTable.MemberID
GROUP BY MemberInfo.Units, MemberInfoSubTable.Article,
Article.Description, MemberInfoSubTable.Finding;


Pivot table:

TRANSFORM Count([PivotTable].[Finding]) AS CountOfFinding
SELECT [PivotTable].[Article], [PivotTable].[Description],
Count([PivotTable].[Finding]) AS Total
FROM PivotTable
GROUP BY [PivotTable].[Article], [PivotTable].[Description]
PIVOT [PivotTable].[Units];