Criteria is entered in 2 columns, query is only utilizing one set of criteria
in [Queries]
|
Prev: Query using only criteria for one column when 2 are limited
Next: Criteria is entered in 2 columns, query is only utilizing oneset of criteria
From: Jeff Boyce on 8 Apr 2010 15:12 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" <rita.brasher(a)fedex.com> wrote in message news:egvxz301KHA.348(a)TK2MSFTNGP02.phx.gbl... > 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??? |