Query: return value if within + or - 10% of entered value?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all, i am quite new to Access and have struggled for a few days tryiny to
find a way to achieve this.

I would like to be able to return records that have a selling price of
within 10% of the value i enter as in [enter selling price].

I do not want to have to type in 2 values.

any help or suggestions would be greatly appreciated.

many thanks
 
Hello again. strangely i think i have solved this problem.

i have used Between [enter value]*0.9 And [enter value]*1.1

and this seems to be working? I thought i had already tried this but i kept
on getting a syntax error.

I would still appreciate if someone could tell me if the above is the best
way to achieve the desired result?

many thanks
 
That is how I would do it.

Maax said:
Hello again. strangely i think i have solved this problem.

i have used Between [enter value]*0.9 And [enter value]*1.1

and this seems to be working? I thought i had already tried this but i
kept
on getting a syntax error.

I would still appreciate if someone could tell me if the above is the best
way to achieve the desired result?

many thanks


Maax said:
Hi all, i am quite new to Access and have struggled for a few days tryiny
to
find a way to achieve this.

I would like to be able to return records that have a selling price of
within 10% of the value i enter as in [enter selling price].

I do not want to have to type in 2 values.

any help or suggestions would be greatly appreciated.

many thanks
Click to expand...
Click to expand...
 
Thanks David

David F Cox said:
That is how I would do it.

Maax said:
Hello again. strangely i think i have solved this problem.

i have used Between [enter value]*0.9 And [enter value]*1.1

and this seems to be working? I thought i had already tried this but i
kept
on getting a syntax error.

I would still appreciate if someone could tell me if the above is the best
way to achieve the desired result?

many thanks


Maax said:
Hi all, i am quite new to Access and have struggled for a few days tryiny
to
find a way to achieve this.

I would like to be able to return records that have a selling price of
within 10% of the value i enter as in [enter selling price].

I do not want to have to type in 2 values.

any help or suggestions would be greatly appreciated.

many thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top