Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Problem with query (Access 1001)

    I have two tables, client and services. I appended records today to the services table from April to May. The two tables are tied together with an appropriate primary/foreign key, which has proven to work in other situations. Next a query was developed with just the service table all April to November service records show appropriately. Next the client table was added to the QBE at this point the April to May records no longer show. This is without adding a field from the client table.

    Does anyone have any ideas of what the problem is? Thank you for your help.

    Have a happy turkey day. Keep your family close. Fay

  2. #2
    Lounger
    Join Date
    Aug 2001
    Location
    Texas, USA
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem with query (Access 1001)

    Is the client key updated as well?

    Dan

  3. #3
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem with query (Access 1001)

    That is a possibility. I guess that will need to be checked next week. Thanks

    Have a good holiday.

    Fay

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Problem with query (Access 1001)

    Did you use an inner join between the two tables (all records that exist in both tables) ? If so, you need to check those new service records to make sure that a matching client record exists for each of them.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •