Results 1 to 4 of 4
  1. #1
    dylan_dog is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2012
    Posts
    9

    query doesn't return anything for some records

    Hi all,



    I have a problem with a query. There are two tables, first with complete guest data and second with logs of his activity. Tables are conected via guest ID. I have a query that pulls data from both tables with the guest ID as a query criteria (ID is pulled from the second table via dropbox, so it's 100% correct). The only problem is that for some guests it works and for the others it just doesn't. I also noticed that for those guests the query doesn't work there is no data when I press the + sign for the record in my main table, even if that guest exists in the second table. I included the picture of the tables. For Grazzi the query works, for Grbac it doesn't. Do you have any idea why? I'm lost and also sure that it is something trivial :-).

    Regards, Samo

  2. #2
    RayMilhon is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,067
    Other than the fact the 2 GRBAC's highlighted are 2 different people with different ID numbers Nothing jumps out.

  3. #3
    dylan_dog is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2012
    Posts
    9
    Hi,

    the records to compare are GRBAC JANEZ and GRAZZI TIZIANO. When I expand both records, the data from related table is visible only for GRAZZI, but not for GRBAC (it should reflect 12 entries in tblTHW). I attached the picture with expanded table and query results for me.

    Thanks, Samo

  4. #4
    RayMilhon is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,067
    Have you verified that GRBAC, JANEZ is in both tables and the ID Numbers match?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Simple query doesn't return anything
    By lbytesxk in forum Queries
    Replies: 6
    Last Post: 09-15-2011, 06:50 AM
  2. Query doesn't return all data
    By hawzmolly in forum Queries
    Replies: 6
    Last Post: 03-26-2010, 09:12 AM
  3. Return all records from Query
    By ysrini in forum Queries
    Replies: 1
    Last Post: 01-15-2010, 09:52 PM
  4. Replies: 0
    Last Post: 08-04-2009, 08:51 PM
  5. Return records not updated by update query
    By ars80 in forum Queries
    Replies: 2
    Last Post: 05-01-2006, 09:23 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums