Re: Query Relationship\Multiple Join

From: Carol Giannini (CarolGiannini_at_discussions.microsoft.com)
Date: 12/07/04 

Date: Tue, 7 Dec 2004 09:45:36 -0800

John - I've included the Or Is Null in the expression for Record_1.ID, and
the query still shows only the clients that have two records. I don't know
the answer to this question: Will Is Null include records that don't exist,
or does there have to be a record with nothing in the specified field? In my
project, the second table will never include records where the ID is null;
there will simply be no second record, and I'm wondering if that's the
problem. Thanks *very much* for your help. I'd really like to find a
solution to this issue; it will make a huge difference in the project I'm
working on.

"John Vinson" wrote:

> On Mon, 6 Dec 2004 18:43:02 -0800, "Carol Giannini"
> <CarolGiannini@discussions.microsoft.com> wrote:
>
> >I've joined the second table to the first table twice, using a left outer
> >join, with criteria Record_1.ID > Record.ID. This works great *IF* a client
> >has two entries in the second table. Queries on clients with no entries or
> >one entry don't work. Can this be done this way? What am I missing? TIA.
>
> If Record_1.ID might not exist, you need to allow for the possibility
> that it is NULL instead of greater than Record.ID:
>
> Record_1.ID > Record.ID OR Record_1.ID IS NULL
>
>
> John W. Vinson[MVP]
> Join the online Access Chats
> Tuesday 11am EDT - Thursday 3:30pm EDT
> http://community.compuserve.com/msdevapps
>

Relevant Pages

  • Re: Creating a wildcard search for a form - Searching for information in a field divided by commas?
    ... guests listed in the field e.g Peter, James, John it is possible to ... > telling it which control on that form to use therefore I think your query is ... >> is also possible that there are multiple entries for the guests in the ...
    (microsoft.public.access.queries)
  • Re: Group Header with Multiple Keywords
    ... In that case you will need to use a UNION query on your Companies and Persons tables, to combine them into one long list. ... persons) are in the one table of Clients. ... > Smith, John 555-3133 ...
    (microsoft.public.access.reports)
  • Re: Delete Duplicates
    ... The third option, delete query & run. ... I want to mail to clients that have account A but not Account ... then use the wizard to build a "find duplicates" ... John Smith, 1234 Elm Street ...
    (microsoft.public.access.gettingstarted)
  • Re: Notation for greater than/less than when entering data?
    ... As I have thousands of entries in ... the Excel file, I was hoping that there was some notation that can be used to ... text strings by checking for the characters in a Query. ... John W. Vinson ...
    (microsoft.public.access.gettingstarted)
  • query criteria
    ... I have a series of checkboxes on a form that represent several steps in a ... I am attempting to write a query that allows users to search by last ... If, for example, the user was querying to see which clients had completed ... How can I write my query to search for entries that have a "-1" in step 3 ...
    (microsoft.public.access.queries)
Loading