Access - insert based on sum by group

[Mariyka1]

Hi if anyone could help with this I would really really appreciate it. I have a table in access which has 9 columns.

Market / Manager /RM / Company/ Site / ID/ Time Frame / Type / Type Count

I want to be able to insert new rows based on the sum of "Type Count" and the "Time Frame"
there are 3 different time frames (30 days, QTD and YTD)
so based on the sum of the count - if its zero then insert a one for every time frame. I'm trying to get a count for all the companies that havent been contacted within each given time frame.

any insite is very much appreciated!

 

[jackd]

I'm trying to get a count for all the companies that havent been contacted within each given time frame.

How do you identify contact with a Company? Seems that is key to any solution, but we need more details to offer more focused response.

 

[xenou]

Hi, In a general sort of a way you could probably break this problem into two parts: 1) getting the sum of the count and 2) doing the insert. Very likely it's the first that is the most important - work on that one and don't worry about the second yet... Also I would suggest you post some sample data and whatever sql you have tried so far (whether or not its working)...