Accessing Query via VBA

[Montez659]

So, as stated in an earlier post, I am fairly new to VBA within Access (worked within Excel for years) so I don't have much exp on databases. I created a query (Metrics) to filter my table (Tasks) down to the appropriate month. How can I access this query by VBA and refine my statistics even further? Eventually, I want to find if the completion date of an activity was less than or equal to the start date + 14 days. All I really need is a count of records for most of what i am doing and not individual data (unless comparing begDate and endDate).

Thanks for the repeated help. Oh, and please don't just do it for me, but help me to learn!

 

[james_lankford]

you don't really need vba for that

you can do that with just a normal query

http://www.techonthenet.com/access/functions/numeric/count.php

http://www.techonthenet.com/access/functions/date/dateadd.php

http://www.techonthenet.com/access/functions/date/datediff.php

the only reason to do it with vba is if you want to write it to a file or run it from within excel, but even then you could do most of it with a query

 

[Montez659]

Thanks for the response. I was trying to do it all "behind the scenes" so as to avoid user confusion when they see twenty queries and I wouldn't want them to mess the info up. I found out that I am able to hide these queries from being viewed, but is there any way to lock them for editing? That would be the last level of protection that I would need. Thanks for your help!