Between Condition is used to retrieve values within a range

[azhar2006]

Hello Guys
You design a query that includes fields from the first number and the second to
What I want is
How do I add a field inference looking for number falls between two numbers


For example
The first field contains the number 100120
The second field contains the number 100130
I want to type in the search field or combo box No. 100122 or 100127
Show me the record above
If I type 100 133 is not shown because it is not located between the two figures above.
SELECT tblCategory.CustomerID, tblCategory.Of, tblCategory.To, tblCategory.Category, tblCategory.Qty, tblCategory.CustomerName, tblCategory.DateOf
FROM tblCategory;

[azhar2006]

I do I enter a number in a text field unstructured (100300113)
Greater than (Field Of)
Smaller than (Field To)

[orange]

This is NOT rocket science. Identify the operator and look to google/bing to find an example with documentation.

For SQL look for examples at w3schools.

For Between http://www.w3schools.com/sql/sql_between.asp

For vba/Access functions see examples at TechOnTheNet

eg Datepart http://www.techonthenet.com/access/f...e/datepart.php

[trevor40]

in the query criteria add

first field 'OF'
>[Enter first value]

on the same query line put

second field 'AS'
<[Enter second value]

Ps having fields named AS and OF could cause you problems

try tblOF and tblAS

[azhar2006]

Good morning Trevor
Thank you all
But how do I put a field on the form
For the purpose of search

[azhar2006]

Thank you Orange cat
This is what I hoped
SELECT *
FROM Table1
WHERE Field BETWEEN Field2 AND Field3;

[trevor40]

between < Forms![your form name]![form field 1] and > Forms![your form name]![form field 2]

try using the build optin to find your form then select from the field list the 2 fields