Criteria is entered in 2 columns, query is only utilizing one setof criteria

[Rita Brasher]

Access 2007

I have a flight column and a date column. There are specific flights for
specific dates I want to see data for.

The query is returning the right flights, but ALL dates, not limited to
the ones I want. If I remove the flight criteria, it 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???

 

[Jeff Boyce]

Why post twice? Folks volunteer their time here, so if no one responds
right away, maybe they're busy or don't know or ...

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.

 

[Rita Brasher]

My second post was a spelling correction and I thought the first one was
deleted...