I am want to be able to choose a press # to a another Press #. The table I am using is a linked table. I am thinking that you use the "between,and" function. But I don't know how to write the fuction so it works. This query is being used for a report. The name of the field is EQNO. I hope this is enough data to help with this.

Between [StartNumber] And [EndNumber] in the criteria for EQNO you may have to define the Parameters

Rich,

Is there any way I could enter that info as a question. Like in some cases say if you are printing a report out. You can put in the query for that report. [enter shift] or something to that effect, but get a range while doing this. I know you can do a between date and another date. I have tried this one for example,
between[forms]![enter EQNO].[Eqno] and [forms]![enter Eqno].[Eqno]

But that don't do anything.

Please help thanks

You could use two unbound fields on your form and tie your criteria in the query to them. Make sure the form is still open when you run your query, however.
Also make sure the Between statement makes sense for your EQNO field. Numbers sort in order, Text fields sort alphabetically.

HTH,
David R