Query using only criteria for one column when 2 are limited
in [Queries]
|
Prev: Criteria is entered in 2 columns, query is only utilizing one setof criteria
Next: Criteria is entered in 2 columns, query is only utilizing one set of criteria
From: Rita Brasher on 8 Apr 2010 15:05 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
From: Jeff Boyce on 8 Apr 2010 15:12 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. "Rita Brasher" <rita.brasher(a)fedex.com> wrote in message news:%237vbk501KHA.4560(a)TK2MSFTNGP02.phx.gbl... > 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
From: Rita Brasher on 8 Apr 2010 15:18 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" On 4/8/2010 2:05 PM, Rita Brasher wrote: > 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
From: Rita Brasher on 8 Apr 2010 15:19
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" On 4/8/2010 2:05 PM, Rita Brasher wrote: > 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 |