Hi,
I am trying to open a report that lists all records from a query for a Supplier between 2 dates using a form to input the required parameters.
The 3 parameters are;
Start Date
End Date
Supplier
These are on the form as unbound fields.
In the query I have the following criteria;
Date; Between [Forms]![frmSearchSupp]![txtStartDate] And [Forms]![frmSearchSupp]![txtEndDate]
Supplier; [Forms]![frmSearchSupp]![txtSupplier]
The report opens OK if I just use the date criteria but it displays no records at all when I use the Supplier criteria as well.
Would appreciate any guidance on this.
Thanks Mick
I am trying to open a report that lists all records from a query for a Supplier between 2 dates using a form to input the required parameters.
The 3 parameters are;
Start Date
End Date
Supplier
These are on the form as unbound fields.
In the query I have the following criteria;
Date; Between [Forms]![frmSearchSupp]![txtStartDate] And [Forms]![frmSearchSupp]![txtEndDate]
Supplier; [Forms]![frmSearchSupp]![txtSupplier]
The report opens OK if I just use the date criteria but it displays no records at all when I use the Supplier criteria as well.
Would appreciate any guidance on this.
Thanks Mick