Help w/ multiple conditions on same hierarchy

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,

I need to specify two conditions from the same hierarchy and am running
into problems. As an example, how could I create a query (from the
Foodmart DB) that shows total USA Warehouse Sales , but excludes the
Los Angeles Stores? In addition, I need my results to be at the Country
level. The problem I can't seem to overcome is filtering on both the
Country AND the city. Any help would be much appreciated.

Thanks,

Bill Adams

.

Relevant Pages

  • Re: Searching for Key Words in a String of Text
    ... I pull the transaction text from a query. ... this text from the memo field of a table, but the problem is that my country ... 65,000 records of bank transactions and flag those transactions that contain ...
    (microsoft.public.access.queries)
  • Re: Searching for Key Words in a String of Text
    ... don't see why the query you posted works any better than ... this text from the memo field of a table, but the problem is that my country ... 65,000 records of bank transactions and flag those transactions that contain ...
    (microsoft.public.access.queries)
  • Re: Searching for Key Words in a String of Text
    ... Unless your query is more complex than the simple outline I ... 65,000 records of bank transactions and flag those transactions that contain ... I would like to have a query that assigns a risk score to each transaction ... based on which country names appear in the text. ...
    (microsoft.public.access.queries)
  • Re: Searching for Key Words in a String of Text
    ... This seems to be effectively creating an inner join between the memo field ... The query still runs slowly, but is a bit faster than when I pull data from ... this text from the memo field of a table, but the problem is that my country ... 65,000 records of bank transactions and flag those transactions that contain ...
    (microsoft.public.access.queries)
  • Re: Searching for Key Words in a String of Text
    ... I've made most of my primary queries into make-table queries so that I only ... Unless your query is more complex than the simple outline I ... I would like to have a query that assigns a risk score to each transaction ... based on which country names appear in the text. ...
    (microsoft.public.access.queries)