I have a query called qryPolicies which in the field DateSubmitted has the criteria:
Between [Enter Start Date] And [Enter End Date]
I'd like to use this query as the basis for several crosstab queries which count the number of policies between the dates entered according to eg. No of Policies per Product/Product Type or Provider/Product.
If there is no criteria in qryPolicies it works beautifully. If there is I get the message "The Microsoft Jet database engine does not recognise '[Enter Start Date]' as a valid field name or expression.
I've read solutions on EE for entering query parameters but the solutions I've found seem to only deal with a single entry into the field ie. one date, not two like this.
So how do I go about it?
Start Free Trial
