Table1:
Company| Division| Year | Accounting Date| Item Number  |  CO No
999         |  101     | 2009| 02/Feb/2009     |  FKAFF000      |  0011012704
999         |  101     | 2009| 03/Feb/2009     |  FFAAZ010      |   0011012705
 
Data type for Accounting Date is Date Time.
 
Table2:
Company| Facility|  Costing Date| Item Number  |  Value Component1
999         |  11     |  20081224     |  FKAFF000      |  0.3938
999         |  11     |  20071201     |  FFAAZ010      |  0.8393
999         |  11     |  20080601     |  FKAFF000      |  0.4633
999         |  11     |  20070101     |  FFAAZ010      |  0.8685
 
Data type for Costing Date is Number.
 
My Report need look like this:
 
Accounting Date | Item No    | CO No          |Value Cost  |Costing Date
02/Feb/2009      | FKAFF000  | 0011012704| 0.3938       | 20081224
03/Feb/2009      | FFAAZ010 | 0011012705 | 0.8393       | 20071201
 
Based on the Accounting Date and choose the nearest costing date value to display.
 
How to do for this. I have no idea to do this. Please help.
 
Really need HELP! Thank you very much.....