Using Between and a Parameter in a query

[spidge32]

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.

[June7]

That really is only one input parameter because they are the same text. Change one or both, like:

BETWEEN [start] AND [end]

If you enter ACT and QLD you will get ACT, NSW, QLD. Is that what you would expect?

[ranman256]

between using States, may only work alphabetically. Between ACT & BOB should only result in ACT.

if you want random states, use a tPicklist table for user to dbl-click a list of states, and it adds them to table tPicklist.
join your table to tPicklist to get only those states in the result.

using a form, you can use dates in a query like:
select * from table where [dateFld] between forms!fMyForm!txtStartDate and between forms!fMyForm!txtEndDate