Need Help with writing Query for TWO TABLES

[taimysho0]

Hello, i have a table (table 1) with 2 columns (serial, and due date)



i also have another table (table 2) that shows (date requested)

i want the proper due date to show up for the date requested (whatever 'due date' is closest to the date requested (from table 2) should be displayed) . Also, this depends on what serial it is as well. Its a little confusing so i have some pictures below



so, on the table with "serial" and "due date", each serial corresponds to 1 due date per month, all the way from B-Z.


please let me know if more clarification is needed. thanks!

[taimysho0]

something along the lines of if...serial B and date requested = 1/17/2012 then
due date = 1/25/2012 (closest due date from the "due date column" for serial B)

[alansidman]

duplicate posting
https://www.accessforums.net/queries...ble-21021.html

[taimysho0]

wasnt sure if this was a query or programming issue..

[orange]

something along the lines of if...serial B and date requested = 1/17/2012 then
due date = 1/25/2012 (closest due date from the "due date column" for serial B)

There is a post here where someone was looking to find the "closest" date. It may be helpful.
http://www.mrexcel.com/forum/showthread.php?t=605407