Unanswered: Need learning material for building queries & basic vba
for my work i use ms access 2-3 times a year.
i only use the queries builder as i am analysing data.
in the past i have only used the queries feature to run my testing and have limited exposure to using the SQL feature and how to build use modules (primarily to build custom functions).
i have searched for info on the net and found odds and ends here and there.
however, every now & then there is a 'best site' that every one knows about and refers to.
therefore, if someone knows of a good place that would explain some of the basics of buidling modules and vba as well as more advanced (such as the simple things that i recently learned that a ' enables you to add text. that Public Function builds a function, that 'end' is the end of the funciton.