Hi, I have a basic table and I would like to have a parameter query based on a field to get data equal to or between to parameters.
I have tried several inputs into the query but it only reports the first parameter. below is the criteria. Can I use parameters with between or = < >?
Between [Enter State] And [Enter State] The field has ACT, NSW, TAS, SA, QLD, VIC, WA as the data.
If I enter NSW as the first parameter and enter the query instantly runs and there is no second parameter
Thank you in advance.