I have 2 dates one is my currency($) and the other one is my quote_date y need to compare the date_quote on the table of effective_date end take the more close date to the effective_date
i dont know the basic syntax to do while to the end of the table
Dim quote_date As Date
Dim effec_curr_date As Date
Do While "??????"(end of table)
Loop
i dont know the basic syntax to do while to the end of the table
Dim quote_date As Date
Dim effec_curr_date As Date
Do While "??????"(end of table)
Loop