Results 1 to 3 of 3
  1. #1
    smg is offline Competent Performer
    Windows XP Access 2010 64bit
    Join Date
    Apr 2019
    Posts
    121

    Query Lookup

    I have a table with APR data (below right). I have a query with timesheet date ranges (below left) where I need to calculate the Daily APR for the time period between the two dates. I am not sure how to lookup the dates from the query to calculate Daily APR or how to handle when the date range in the query comes between two different APR amounts. I believe the Daily APR calculation is APR/365*100

    QUERY From To Daily APR TABLE From To APR
    6/23/2019 6/29/2019 1/1/2019 6/30/2019 3.625%
    6/30/2019 7/6/2019 7/1/2019 12/31/2019 2.625%

    Let me know if you can help me get Daily APR for each of the seven day timesheet periods in the query.



    Thanks

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Make a couple queries shown to get the rates:
    Click image for larger version. 

Name:	use dates in rate table.jpg 
Views:	13 
Size:	88.0 KB 
ID:	40004

  3. #3
    smg is offline Competent Performer
    Windows XP Access 2010 64bit
    Join Date
    Apr 2019
    Posts
    121
    thank you ranman256, I am working with this

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

Similar Threads

  1. Replies: 9
    Last Post: 10-10-2019, 05:13 PM
  2. Replies: 4
    Last Post: 03-17-2016, 07:16 AM
  3. Lookup values not appearing in Lookup field?
    By dominover in forum Access
    Replies: 4
    Last Post: 03-05-2016, 05:01 PM
  4. Replies: 4
    Last Post: 07-28-2015, 10:14 AM
  5. Replies: 3
    Last Post: 05-08-2015, 11:08 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