Multiple Query questions

  • Thread starter Thread starter Jackie
  • Start date Start date
J

Jackie

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.
 
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.
Click to expand...

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.
 
Back
Top