QUERY QUESTION

A

anill

Hi I use MS ACCESS 2000 and I would like to help me with a Query
I would like to find from all my products all the prices from 400 t
799
How I can do that

Thank you in adnvance
 
J

John Spencer (MVP)

You need to put in criteria againstthe price field. Assuming you are using the
query grid.

Field: PriceField
Criteria: Between 400 and 799


An alternate method would be

Field: PriceField
Criteria: >=400 and <800
 
J

John Vinson

Hi I use MS ACCESS 2000 and I would like to help me with a Query.
I would like to find from all my products all the prices from 400 to
799.
How I can do that ?

Thank you in adnvance.
Click to expand...

Create a Query.

On the criteria line under the price field put

BETWEEN 400 AND 799

Open the query.

John W. Vinson[MVP]
 
Top