VBA SQL How to design an update query with a changing where clause
Posted on 2014-04-07
Good Morning Guru's
I am hitting a wall with this. Here's the deal.
Platform: Access 2010
Programming data model: DAO
issue: I have to update a table to based upon data in that table based on specific criteria.
For example, we have to get the "total's" for a number of groups
Each group will have a different number of subgroups
so, say there is Grp1, and Grp1 has Grp1sub1, Grp1sub2 - and the sub groups need some values totaled.
Now say, there is Grp2 and Grp2 has Grp2sub1, Grp2sub2, Grp2sub3, Grp2sub4 - and these sub groups need there values totaled also.
I am having an issue with creating a query in VBA and will adjust the query statement to handle the different number of subgroups for each Group.
Is this at all possible?