By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,594 Members | 3,552 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,594 IT Pros & Developers. It's quick & easy.

Filtering a numeric field with command "Like [.....]" as criteria in a query

P: n/a
Dear reader,

How can I filter a numeric field with Like[....] as criteria in a query.

To filter a numeric field with <10 as criteria this will com back with the
result of those records for which the value is smaller as teen.

But in case this value is variable and you prefer to work with "Like
[.....]' in the criteria of the query then the query will be comeback with
zero records after typing <10.

I think this happens because the value you types will be altered between
quotes "<10" after the Like command in the criteria.

These quotes are not allowed for filtering of a numeric field.

Is there any possibility to work with variable values in the criteria for
numeric fields in a query?

Thanks for any help.

Kind regards,

Simon van Beek

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"S. van Beek" <S.******@HCCnet.nl> wrote in message
news:42*********************@reader2.nntp.hccnet.n l...
Dear reader,

How can I filter a numeric field with Like[....] as criteria in a query.

To filter a numeric field with <10 as criteria this will com back with the
result of those records for which the value is smaller as teen.

But in case this value is variable and you prefer to work with "Like
[.....]' in the criteria of the query then the query will be comeback with
zero records after typing <10.

I think this happens because the value you types will be altered between
quotes "<10" after the Like command in the criteria.

These quotes are not allowed for filtering of a numeric field.

Is there any possibility to work with variable values in the criteria for
numeric fields in a query?

Thanks for any help.

Kind regards,

Simon van Beek

In the criteria row put <[Some Value]. Additionally you can set
Query>Parameters and set a data type for the parameter. When you have
finished, the SQL for the query should look something like this:

PARAMETERS MyNumericValue Long;
SELECT MyTable.*
FROM MyTable
WHERE MyField<[MyNumericValue]




Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.