I'm trying to query a database of beach rentals and need a query with more 
than 2 bedrooms, that rents for less than 1,000. When i put both criteria in, 
it only registers one of them.

I also need to create a query for the highest and lowest weekly rate but 
when I select  Min or Max or doesn't show me anything.

Show us the SQL.  Open the query in design view. Next go to View, SQL View 
and copy and past it here. 
-- 
Jerry Whittle, Microsoft Access MVP 
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Jackie" wrote:

> I'm trying to query a database of beach rentals and need a query with more 
> than 2 bedrooms, that rents for less than 1,000. When i put both criteria in, 
> it only registers one of them.
> 
> I also need to create a query for the highest and lowest weekly rate but 
> when I select  Min or Max or doesn't show me anything.

On Thu, 22 Apr 2010 06:49:02 -0700, Jackie <Jackie@discussions.microsoft.com>
wrote:

>I'm trying to query a database of beach rentals and need a query with more 
>than 2 bedrooms, that rents for less than 1,000. When i put both criteria in, 
>it only registers one of them.
>
>I also need to create a query for the highest and lowest weekly rate but 
>when I select  Min or Max or doesn't show me anything.

Correct the errors in your query. If you would like help doing so open the
query in SQL view and post it here so someone else can see it.
-- 

             John W. Vinson [MVP]