Results 1 to 4 of 4
  1. #1
    damngroundhog is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2019
    Posts
    5

    Linked table working only for items that are equal


    Hello. Let me preface by saying i have been using access for about 2 days. I have a table which hosts my job data. I need to track when the status changes from new, to working to complete. My first table is for my jobs. it has 2 columns which access a seperate status table. Those 2 columns are called status ID. The status table takes the status ID and gives it its proper reference, new, working or closed. I need to calculate date difference in these which is why i created it this way. problem is, i only get back the actual reference in a query when it is a new job. When i have 2 different status, It just gives me the id. It is connected in a 1 to many relationship. the status id in the jobs table links to the status id in the status table. I hope my request is clear. thanks for all the help groundhog

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    If I understand correctly, you need to put the status table into the design grid twice. Join each of your status fields in the job data to a different instance of the status table. Access will alias one of them like Status_1, which you can change if you want.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    damngroundhog is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2019
    Posts
    5
    Awesome, thanks for the quick reply. It now makes sense as to why this works.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Happy to help and welcome to the site!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 2
    Last Post: 04-15-2014, 10:03 PM
  2. Replies: 3
    Last Post: 04-13-2012, 10:39 AM
  3. linked table refresh in 2010 not working in 2000
    By bbbeng in forum Import/Export Data
    Replies: 3
    Last Post: 12-20-2011, 01:25 PM
  4. Linked tables need values that are NOT EQUAL
    By gus1339 in forum Queries
    Replies: 3
    Last Post: 04-11-2011, 06:55 PM
  5. linked table long query not working
    By mirthcyy in forum Queries
    Replies: 4
    Last Post: 09-23-2010, 03:16 PM

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