If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
insert rows after count
Query shows 5 years of data for various accounts. Some accounts may not have
5 years of data however I want rows added with the year that doesn't have activity that shows year and group number. Each yr is listed in a row with a group number that is the same for each year. This info will be exported into Excel template where graphs will be made on each group of data. This way I won't have to create multiple graphs each update nor format graphs based on number of years imported. |
#2
|
|||
|
|||
insert rows after count
This can be handled with a LEFT join. However, we will need to know the
details of your tables containing the data. -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "Ginger" wrote: Query shows 5 years of data for various accounts. Some accounts may not have 5 years of data however I want rows added with the year that doesn't have activity that shows year and group number. Each yr is listed in a row with a group number that is the same for each year. This info will be exported into Excel template where graphs will be made on each group of data. This way I won't have to create multiple graphs each update nor format graphs based on number of years imported. |
Thread Tools | |
Display Modes | |
|
|