access form seach: how to set tolerances to guide results given?

[Guest]

I want a form to give results from a database that are closest to the values
entered (within a tolerance that I would like to be able to set). Of the two
values, I would like one to have priority over the other for the values
returned. Is this possible? Help? Thanks!!

 

[Guest]

Use the following --
SELECT [YourTable-1].num, [Enter value] AS x, [Enter lower limit from value]
AS Y, [Enter upper limit from value] AS Z
FROM [YourTable-1]
WHERE ((([YourTable-1].num) Between [Enter value]-[Enter lower limit from
value] And [Enter value]+[Enter upper limit from value]));

 

[Rick B]

You'd need to give us a bit more specific information.

Certainly you can do something like...

Between [Entervalue]-10 and [Entervalue]+10

....to find values 'close' to an entered parameter.

 

[Guest]

Are you saying to use a query in a form? How would I attempt that?

Use the following --
SELECT [YourTable-1].num, [Enter value] AS x, [Enter lower limit from value]
AS Y, [Enter upper limit from value] AS Z
FROM [YourTable-1]
WHERE ((([YourTable-1].num) Between [Enter value]-[Enter lower limit from
value] And [Enter value]+[Enter upper limit from value]));

I want a form to give results from a database that are closest to the values
entered (within a tolerance that I would like to be able to set). Of the two
values, I would like one to have priority over the other for the values
returned. Is this possible? Help? Thanks!!

 

[Guest]

Okay in a form, I have the user enter in two values say temperature and
humidity. Now, humidity is more important and temp is secondary, but there
may not be a record that matches either exactly, so I want to be able to have
them type in 50 and 80 and then have the form spit out results that are close
(or exactly match) what the user entered. Currently, I have a box where they
can enter the "tolerance", but ideally I don't want the user to be able to
change the tolerance, I want the form to automatically only provide results
consistent with the tolerance I set.

You'd need to give us a bit more specific information.

Certainly you can do something like...

Between [Entervalue]-10 and [Entervalue]+10

....to find values 'close' to an entered parameter.



--
Rick B

I want a form to give results from a database that are closest to the values
entered (within a tolerance that I would like to be able to set). Of the two
values, I would like one to have priority over the other for the values
returned. Is this possible? Help? Thanks!!

 

[Guest]

Yes, use the query as the record source.

Are you saying to use a query in a form? How would I attempt that?

Use the following --
SELECT [YourTable-1].num, [Enter value] AS x, [Enter lower limit from value]
AS Y, [Enter upper limit from value] AS Z
FROM [YourTable-1]
WHERE ((([YourTable-1].num) Between [Enter value]-[Enter lower limit from
value] And [Enter value]+[Enter upper limit from value]));

I want a form to give results from a database that are closest to the values
entered (within a tolerance that I would like to be able to set). Of the two
values, I would like one to have priority over the other for the values
returned. Is this possible? Help? Thanks!!

 

[Guest]

Use Rick B said like this --

Temperature fields criteria -
Between [Enter Temp value]-10 and [Enter Temp value]+10

Okay in a form, I have the user enter in two values say temperature and
humidity. Now, humidity is more important and temp is secondary, but there
may not be a record that matches either exactly, so I want to be able to have
them type in 50 and 80 and then have the form spit out results that are close
(or exactly match) what the user entered. Currently, I have a box where they
can enter the "tolerance", but ideally I don't want the user to be able to
change the tolerance, I want the form to automatically only provide results
consistent with the tolerance I set.

You'd need to give us a bit more specific information.

Certainly you can do something like...

Between [Entervalue]-10 and [Entervalue]+10

....to find values 'close' to an entered parameter.



--
Rick B

I want a form to give results from a database that are closest to the values
entered (within a tolerance that I would like to be able to set). Of the two
values, I would like one to have priority over the other for the values
returned. Is this possible? Help? Thanks!!

 

[Guest]

Would I do a query for each value? Is there a way to put priority over one
query?

Yes, use the query as the record source.

Are you saying to use a query in a form? How would I attempt that?

Use the following --
SELECT [YourTable-1].num, [Enter value] AS x, [Enter lower limit from value]
AS Y, [Enter upper limit from value] AS Z
FROM [YourTable-1]
WHERE ((([YourTable-1].num) Between [Enter value]-[Enter lower limit from
value] And [Enter value]+[Enter upper limit from value]));


:

I want a form to give results from a database that are closest to the values
entered (within a tolerance that I would like to be able to set). Of the two
values, I would like one to have priority over the other for the values
returned. Is this possible? Help? Thanks!!

 

[Guest]

I do not understand your question of priority. Do you want the one that is
the closest to the value as priority? You will be getting both temperature
and humidity at the same time - no priority.

Do you want to sort them in how close they are to the value entered?

Would I do a query for each value? Is there a way to put priority over one
query?

Yes, use the query as the record source.

Are you saying to use a query in a form? How would I attempt that?

:

Use the following --
SELECT [YourTable-1].num, [Enter value] AS x, [Enter lower limit from value]
AS Y, [Enter upper limit from value] AS Z
FROM [YourTable-1]
WHERE ((([YourTable-1].num) Between [Enter value]-[Enter lower limit from
value] And [Enter value]+[Enter upper limit from value]));


:

I want a form to give results from a database that are closest to the values
entered (within a tolerance that I would like to be able to set). Of the two
values, I would like one to have priority over the other for the values
returned. Is this possible? Help? Thanks!!