+ or - 100

[fishhead]

How would i create a criteria in a query that would return all records + or - 100 of the value in a field of a form. Note this text field only has numbers in it (no text)

eg.
([Forms]![fCreateBilling]![Text161])


has the number 1000 in it. I'm looking for a criteria that will return all records that have a value in this field between 900 and 1100

the criteria i'm using is ...
([Forms]![fCreateBilling]![Text161]),+-100
but this just causes errors

can someone please help?

tks

[ssanfu]

In the criteria row for the field,

> 900 and <1100 'does not include 900 or 1100

If you want to include the 900 and 1100, then
Between 900 and 1100 'includes 900 and 1100
or
>= 900 and <= 1100 'includes 900 and 1100


The WHERE clause of the query:

WHERE fCreateBilling!Text161 Between 900 And 1100;

or

WHERE fCreateBilling!Text161 >= 900 and <= 1100;

EDIT:
I might have misread the question.

If you have a control on a form, the value in the control is 1000 and you want all records that are +-100 of that value, then try

The WHERE clause of the query:

WHERE theField Between [Forms]![fCreateBilling]![Text161]-100 And [Forms]![fCreateBilling]![Text161]+100;

Change theField to your field name


-------------------------------------------------------------------------------------------
In the criteria row for the field,

> [Forms]![fCreateBilling]![Text161]-100 and <[Forms]![fCreateBilling]![Text161]+100
>= [Forms]![fCreateBilling]![Text161]-100 and <=[Forms]![fCreateBilling]![Text161]+100

Between [Forms]![fCreateBilling]![Text161]-100 And [Forms]![fCreateBilling]![Text161]+100

[fishhead]

this works perfectly! thanks

[ssanfu]

You're welcome. I will mark this solved for you.....