I'm struggling trying to figure out how to write a query via code that will pull data from an Access DB. I have looked at several examples that have already been posted but I'm unable to figure out how to make it work for my needs. I think my problem is I'm not understanding what all is required and what each line of code that I have found is saying.
I would like to pull data from several different tables in the db based on 2 criteria. 1. a date range and 2. a "station name". So in summary I want data collected betweek xx date and xx date with the station name "line 1".
Below is some code I have been messing with but get errors when trying to run. I don't think I'm even close. If someone has a basic query they could show me with an explination of what things are or do then I think I can make this work for me.
This forum has provided me with much help in my quest to learn Excel Programming and I appriciate all the help that has been provided.
If there is a tutorial or some other instruction out there that you have found to be helpful I'm open for suggestions. I don't mind trying to figure things out on my own but thus far I've been stuck on this one.
Thanks in Advance for any and all help.
Bookmarks