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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update query and filter by selection 12
Query with field in a form 2
how to make a query to select the last 3 years 8
A query that shows "deletable" records 2
Very difficult query (?) 9
Access 2000 append unbound text box values to a table 0
#Error when dividing by zero 2
Scrabble Value calculation for Welsh words 0

Back
Top