Results 1 to 3 of 3
  1. #1
    charlieb is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Feb 2015
    Posts
    20

    need help with best method question


    I need to select and compare a value in 2 different tables but I am not sure of the best method to do this. I am an attorney and I represent clients who were injured at work (workers compensation). I have one table that has the date of accident and the amount of clients weekly earnings. The second table shows the maximum amount that an injured worker can be paid per week for each year (when a person gets hurt on the job and can not work in my state they are entitled to receive a certain amount of money until they can go back to work). The idea is to compare the clients' AWW on the date of accident to the maximum the law allows for payments to an injured worker in the year of that accident shown in the second table. For example: Joe has an accident at work in the year 2000. He makes $300 per week before his accident and the law allows him get $300 each week. But if in the year 2000, the law places a maximum cap of how much an injured worker can get paid to say... $175 , then he can only get that much. If the cap for year 2000 is $300 or greater he can get what he used to make. The tables look like this:

    Table 1

    ClientName
    DateOfAccid
    AWW


    Table 2

    Date
    Maximum

    Any help is appreciated.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Try:

    SELECT Table1.ClientName, Table1.DateOfAccid, Table1.AWW, Table2.Date, Table2.Maximum
    FROM Table1, Table2
    WHERE (((Year([Date]))>=Year([DateOfAccid])));


    Date is a reserved word. Should not use reserved words as names.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    charlieb is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Feb 2015
    Posts
    20
    I appreciate the help, I'll change date. Thank you

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

Similar Threads

  1. The DAO OpenDatabase Method
    By tagteam in forum Access
    Replies: 7
    Last Post: 10-25-2013, 03:56 PM
  2. What can be the best method?
    By cap.zadi in forum Database Design
    Replies: 2
    Last Post: 03-04-2013, 10:26 PM
  3. Replies: 4
    Last Post: 01-03-2013, 03:50 PM
  4. Question about best method
    By tdanko128 in forum Programming
    Replies: 2
    Last Post: 01-30-2011, 01:41 PM
  5. Which method is better?
    By undrcvr in forum Database Design
    Replies: 3
    Last Post: 05-24-2010, 12:46 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