Update Access Query save and close through Excel VBA
 

Hello All,

I wish to access an Access Query, update the query, save and close.

Explanation: I have an Access Query (Past Due OERS W/TOTALS) that I have to
open in design mode, right click on the fields labeled:

Late <31 Days: IIf([DATE_END_EVAL_PD] Between "060109" And "060208",1)

Late <61 Days: IIf([DATE_END_EVAL_PD] Between "051209" And "060108",1)

Late <91 Days: IIf([DATE_END_EVAL_PD] Between "051109" And "051208",1)

Late <120 Days: IIf([DATE_END_EVAL_PD] Between "051009" And "051108",1)

Late 120 Days: IIf([DATE_END_EVAL_PD]<"051009",1)

Select Zoom, and update the Between & And Dates (theyre dates formatted in
YYMMDD). Each field label will be updated with different dates.

Using VBA, I know how to open a table, but I cant figure out how to open a
query much less in design mode and get to the specific fields that need
updating.

Any help would be greatly appreciated.