Hi
Referring to "How to get a Running Sum in Queries" faq701-5268
I need assistance to get a running sum on my query, but with a twist. I need to have the running sum add or minus the value based on criteria of another field. The running sum will be used to produce a bar chart. Here's my code minus my attempt at the running sum:
SELECT qry_YellowTags_ChartData.[Outlook Date], Count(qry_YellowTags_ChartTagStatus.[Tag Status]) AS TagCount, qry_YellowTags_ChartTagStatus.[Tag Status], qry_YellowTags_ChartTagStatus.ReleaseStatus, IIf([ReleaseStatus]="Active","Add","Minus") AS AddMinus
FROM qry_YellowTags_ChartTagStatus RIGHT JOIN qry_YellowTags_ChartData ON qry_YellowTags_ChartTagStatus.[Tag No] = qry_YellowTags_ChartData.[Tag No]
GROUP BY qry_YellowTags_ChartData.[Outlook Date], qry_YellowTags_ChartTagStatus.[Tag Status], qry_YellowTags_ChartTagStatus.ReleaseStatus, IIf([ReleaseStatus]="Active","Add","Minus")
ORDER BY qry_YellowTags_ChartData.[Outlook Date];
Thanks in advance for your assistance. BJ
Referring to "How to get a Running Sum in Queries" faq701-5268
I need assistance to get a running sum on my query, but with a twist. I need to have the running sum add or minus the value based on criteria of another field. The running sum will be used to produce a bar chart. Here's my code minus my attempt at the running sum:
SELECT qry_YellowTags_ChartData.[Outlook Date], Count(qry_YellowTags_ChartTagStatus.[Tag Status]) AS TagCount, qry_YellowTags_ChartTagStatus.[Tag Status], qry_YellowTags_ChartTagStatus.ReleaseStatus, IIf([ReleaseStatus]="Active","Add","Minus") AS AddMinus
FROM qry_YellowTags_ChartTagStatus RIGHT JOIN qry_YellowTags_ChartData ON qry_YellowTags_ChartTagStatus.[Tag No] = qry_YellowTags_ChartData.[Tag No]
GROUP BY qry_YellowTags_ChartData.[Outlook Date], qry_YellowTags_ChartTagStatus.[Tag Status], qry_YellowTags_ChartTagStatus.ReleaseStatus, IIf([ReleaseStatus]="Active","Add","Minus")
ORDER BY qry_YellowTags_ChartData.[Outlook Date];
Thanks in advance for your assistance. BJ