form parameter

[T3E]

hi, i would like to know whether some one can give me a criteria for a
parameter query which wil fulfill the following: basically i have a form
consisting of two fields i want the parameter query top use both these
feilds. field 1 is minimum price range and field 2 is maximum price range the
query should display records which come in between the values in the two
field.

i tried something like:
=Between [Form]![formname]![field 1] And [field 2]

it doesn't work its wrong can u give me a correct criteria.

thank you

 

[fredg]

hi, i would like to know whether some one can give me a criteria for a
parameter query which wil fulfill the following: basically i have a form
consisting of two fields i want the parameter query top use both these
feilds. field 1 is minimum price range and field 2 is maximum price range the
query should display records which come in between the values in the two
field.

i tried something like:
=Between [Form]![formname]![field 1] And [field 2]

it doesn't work its wrong can u give me a correct criteria.

thank you

1) You have to repeat the criteria source for each criteria.
2) The correct word is "Forms" not "Form"
3) Do not use the "=" sign when you use "Between".

Between [Forms]![formname]![field 1] And [Forms]![formname]![field 2]

The form must remain open when the qwery is run.