Options>references and the activex libs are checked off. I'm getting an error on the new code saying "user defined type not defined" for the DAO recordset.
I also started working on another piece of code that queries the result of what I sent you and puts it into a VBA variable. may be a little sloopy but it all works except for what i sent you. Here's all the code, probably not the best but again i'm novie with no formal training.
Happy to help ! When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answered StrSQL = "INTO tbl_wkend_date (week_ending) " & _