|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 3rd, 2005, 01:45 PM
|
|||
|
|||
QUERY QUESTION
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. 
|
|
#2
September 3rd, 2005, 02:08 PM
|
|||
|
|||
|
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 anill wrote: 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.
|
|
#3
September 6th, 2005, 05:49 PM
|
|||
|
|||
|
On Sat, 03 Sep 2005 07:45:51 -0500, lid
(anill) wrote: 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. Create a Query. On the criteria line under the price field put BETWEEN 400 AND 799 Open the query. John W. Vinson[MVP]
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Union Query WHERE criteria question | Ladybird | Running & Setting Up Queries | 0 | June 9th, 2005 01:29 AM |
| Query Problem | jacob | Running & Setting Up Queries | 0 | May 26th, 2005 09:46 PM |
| Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
| Big number gives error! | Sara Mellen | Running & Setting Up Queries | 8 | October 11th, 2004 02:48 AM |
| Too Few Parameters error Mail Merge Access Parameter Query | Tony_VBACoder | Mailmerge | 3 | September 14th, 2004 12:15 PM |
Linear Mode
