hello all,
i have a search form company_search with many controls. A query reads
these
controls to use as its criteria(s).

-by the usage of statemts such as:

Like nz([Forms]![company_search]![CompNameEng])

in the query criteria. then the user can type co* and get all the
companies
starting with co, etc.

but when I try to do this with number based fields (for example
compValue),
the user can't type >50 and get all the companies with value greater
than
50....
after all, the Access criteria line accepts >50 in the criteria, so why
not ccept this value passed from a control on a form..?  the query just
diaplays no records.

isn't there a simple way to do this from within the query criteria
without resorting to VBA string processing (which might slow down the
query, as I have 20 different criteria fields on
a single query)

?

thanks for all the help..

Oded

Sent via Deja.com http://www.*-*-*.com/
Before you buy.

hello all,
i have a search form company_search with many controls. A query reads
these
controls to use as its criteria(s).

-by the usage of statemts such as:

Like nz([Forms]![company_search]![CompNameEng])

in the query criteria. then the user can type co* and get all the
companies
starting with co, etc.

but when I try to do this with number based fields (for example
compValue),
the user can't type >50 and get all the companies with value greater
than
50....
after all, the Access criteria line accepts >50 in the criteria, so why
not ccept this value passed from a control on a form..?  the query just
diaplays no records.

isn't there a simple way to do this from within the query criteria
without resorting to VBA string processing (which might slow down the
query, as I have 20 different criteria fields on
a single query)

?

thanks for all the help..

Oded

Sent via Deja.com http://www.deja.com/
Before you buy.

have you tried adding your own SQL statements to the query to get what you
want?