query +/- 5%

  • Thread starter Thread starter Lasse T
  • Start date Start date
L

Lasse T

Hi !!

Hope you can help me with this.

How do I write the formula in a query that will pick all the values within 5
percent up and down from a value I have in an unbound text box in a form?

Thanks in advance

Lasse T
-------------
 
Lasse T said:
Hi !!

Hope you can help me with this.

How do I write the formula in a query that will pick all the values within 5
percent up and down from a value I have in an unbound text box in a form?

Thanks in advance

Lasse T
Click to expand...
=(Forms!frmSomeForm!txtSomeTextBox*0.95) AND
Click to expand...
<=(Forms!frmSomeForm!txtSomeTextBox*1.05)
 
Back
Top