Query using only criteria for one column when 2 are limited

R

Rita Brasher

Access 2007

Among other items in my table, I have a flight column and a date column.
There are specific flights for specific dates for which I'd like to see
data.

The query is returning the right flights, but ALL dates, not limited to
the ones I want. If I remove the flight criteria, it shows all flights,
but limits my dates as desired.

What is the deal? WHY are the simplest of tasks made so much more
difficult in this release of Office???

Rita Brasher
Global Trade Services
FedEx Express
 
J

Jeff Boyce

Rita

It might help us diagnose what's happening if you'd provide the SQL
statement of that query...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
R

Rita Brasher

Never mind. I figured it out. I had to put both flights on one criteria
line separated by "or", rather than utilizing the "OR" that is part of
the criteria design. How asinine. Sure an hell with I wasn't forced to
use Microsoft products. What used to be just a right-click away now
takes 4 drop-down menu clicks to get to when formatting. It's like
Microsoft said, "Let's see how unproductive we can make our users"
 
R

Rita Brasher

Never mind. I figured it out. I had to put both flights on one criteria
line separated by "or", rather than utilizing the "OR" that is part of
the criteria design. How asinine. Sure as hell wish I wasn't forced to
use Microsoft products. What used to be just a right-click away now
takes 4 drop-down menu clicks to get to when formatting. It's like
Microsoft said, "Let's see how unproductive we can make our users"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top