Searching A Database Using Greater & Lesser Than

[Choole]

I have a database with a field called "Value" in one of my tables. This field
is just set as number. I want to be able to search this field so that users can
bring up records in the database. How can i get it working so that instead of
have a long dropdown list of all the values i can just have a search that
offers the user the option to use Greater than "A Value" or Less Than "A Value"

Any help or tutorials would be greatly appreciated.

Many Thanks

[BillB]

SELECT *
FROM tbl_mytable
WHERE fieldA >= '0' AND fieldA <= '1000'


--
Bill
Real Estate Web Sites Made Easy
[url]www.DataPacks.com[/url]


"Choole" <webforumsuser@macromedia.com> wrote in message
news:d1ool1$fpd$1@forums.macromedia.com...

>I have a database with a field called "Value" in one of my tables. This
>field
> is just set as number. I want to be able to search this field so that
> users can
> bring up records in the database. How can i get it working so that instead
> of
> have a long dropdown list of all the values i can just have a search that
> offers the user the option to use Greater than "A Value" or Less Than "A
> Value"
>
> Any help or tutorials would be greatly appreciated.
>
> Many Thanks
>