<?xml version="1.0"?>
<Reports>
  <FormatVersion>1.0 1.0.0.0</FormatVersion>
  <Report ref="1">
    <Name>Running Sums</Name>
    <DataSourceName>Main</DataSourceName>
    <OnPage>pageSum = 0</OnPage>
    <Layout>
      <Orientation>Portrait</Orientation>
    </Layout>
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
      <Bold>false</Bold>
      <Italic>false</Italic>
      <Underline>false</Underline>
      <Strikethrough>false</Strikethrough>
      <GdiCharSet>1</GdiCharSet>
    </Font>
    <DataSources>
      <DataSource>
        <Name>Main</Name>
        <DataProvider>OLEDB</DataProvider>
        <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|C1NWind.mdb;Persist Security Info=False</ConnectionString>
        <RecordSource>Products</RecordSource>
      </DataSource>
    </DataSources>
    <Groups>
      <Group>
        <Name>UnitPrice</Name>
        <GroupBy>UnitPrice</GroupBy>
        <Sort>Descending</Sort>
      </Group>
    </Groups>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>255</Height>
          </SubSection>
        </SubSections>
        <Type>Detail</Type>
        <OnPrint>pageSum = pageSum + UnitsInStock</OnPrint>
      </Section>
      <Section>
        <Name>Header</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>3080</Height>
          </SubSection>
        </SubSections>
        <Type>Header</Type>
      </Section>
      <Section>
        <Name>Footer</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
          </SubSection>
        </SubSections>
        <Type>Footer</Type>
        <Visible>false</Visible>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>600</Height>
          </SubSection>
        </SubSections>
        <Type>PageHeader</Type>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>1080</Height>
          </SubSection>
        </SubSections>
        <Type>PageFooter</Type>
      </Section>
      <Section>
        <Name>UnitPrice Header</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
          </SubSection>
        </SubSections>
        <Type>GroupHeader1</Type>
        <Visible>false</Visible>
      </Section>
      <Section>
        <Name>UnitPrice Footer</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
          </SubSection>
        </SubSections>
        <Type>GroupFooter1</Type>
        <Visible>false</Visible>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>titleLbl</Name>
        <Section>Header</Section>
        <Left>0</Left>
        <Top>1020</Top>
        <Width>3255</Width>
        <Height>600</Height>
        <Text>Running Sums</Text>
        <Align>LeftMiddle</Align>
        <ForeColor>FFC00000</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>18</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>ftrRight</Name>
        <Section>PageFooter</Section>
        <Left>4680</Left>
        <Top>780</Top>
        <Width>4680</Width>
        <Height>300</Height>
        <Text>"Page " &amp; [Page] &amp; " of " &amp; [Pages]</Text>
        <Calculated>true</Calculated>
        <Align>RightTop</Align>
        <Font>
          <Name>Calibri</Name>
          <Size>9</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameLbl</Name>
        <Background type="Solid">
          <Color>FFBFBFBF</Color>
        </Background>
        <Section>PageHeader</Section>
        <Left>0</Left>
        <Top>105</Top>
        <Width>2880</Width>
        <Height>405</Height>
        <Text>ProductName</Text>
        <Align>LeftMiddle</Align>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>11.25</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>UnitPriceLbl</Name>
        <Background type="Solid">
          <Color>FFBFBFBF</Color>
        </Background>
        <Section>PageHeader</Section>
        <Left>3218.75</Left>
        <Top>105</Top>
        <Width>1600</Width>
        <Height>405</Height>
        <Text>UnitPrice</Text>
        <Align>RightMiddle</Align>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>11.25</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>UnitsInStockLbl</Name>
        <Background type="Solid">
          <Color>FFBFBFBF</Color>
        </Background>
        <Section>PageHeader</Section>
        <Left>5232.5</Left>
        <Top>105</Top>
        <Width>960</Width>
        <Height>405</Height>
        <Text>In Stock</Text>
        <Align>RightMiddle</Align>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>11.25</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>ProductNameCtl</Name>
        <Section>Detail</Section>
        <Left>0</Left>
        <Top>0</Top>
        <Width>2850</Width>
        <Height>255</Height>
        <AutoHeight>CanGrow</AutoHeight>
        <Text>ProductName</Text>
        <Calculated>true</Calculated>
        <Align>LeftTop</Align>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>UnitPriceCtl</Name>
        <Section>Detail</Section>
        <Left>3263.75</Left>
        <Top>0</Top>
        <Width>1600</Width>
        <Height>250</Height>
        <Text>UnitPrice</Text>
        <Calculated>true</Calculated>
        <Format>Currency</Format>
        <Align>RightTop</Align>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>UnitsInStockCtl</Name>
        <Section>Detail</Section>
        <Left>5277.5</Left>
        <Top>0</Top>
        <Width>960</Width>
        <Height>250</Height>
        <Text>UnitsInStock</Text>
        <Calculated>true</Calculated>
        <Format>#,##0</Format>
        <Align>RightTop</Align>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>UnitsInStockCtl1</Name>
        <Section>Detail</Section>
        <Left>8130</Left>
        <Top>0</Top>
        <Width>1065</Width>
        <Height>255</Height>
        <Text>UnitsInStock</Text>
        <Calculated>true</Calculated>
        <Format>#,##0</Format>
        <Align>RightTop</Align>
        <RunningSum>SumOverAll</RunningSum>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>UnitsInStockLbl1</Name>
        <Background type="Solid">
          <Color>FFBFBFBF</Color>
        </Background>
        <Section>PageHeader</Section>
        <Left>6606.25</Left>
        <Top>105</Top>
        <Width>1065</Width>
        <Height>405</Height>
        <Text>Page Sum</Text>
        <Align>RightMiddle</Align>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>11.25</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>PageFooter</Section>
        <Left>0</Left>
        <Top>480</Top>
        <Width>8640</Width>
        <Height>270</Height>
        <Text>Format(Page, "Total stock listed on page 0 is: ") &amp; Format(pageSum, "#,##0")</Text>
        <Calculated>true</Calculated>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>pageSum</Name>
        <Section>Detail</Section>
        <Left>6651.25</Left>
        <Top>0</Top>
        <Width>1065</Width>
        <Height>255</Height>
        <Text>pageSum</Text>
        <Calculated>true</Calculated>
        <Format>#,##0</Format>
        <Align>RightTop</Align>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>UnitsInStockLbl2</Name>
        <Background type="Solid">
          <Color>FFBFBFBF</Color>
        </Background>
        <Section>PageHeader</Section>
        <Left>7860</Left>
        <Top>105</Top>
        <Width>1350</Width>
        <Height>405</Height>
        <Text>Overall Sum</Text>
        <Align>RightMiddle</Align>
        <WordWrap>false</WordWrap>
        <Font>
          <Name>Calibri</Name>
          <Size>11.25</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>Field</Name>
        <Section>Header</Section>
        <Left>0</Left>
        <Top>1950</Top>
        <Width>9270</Width>
        <Height>990</Height>
        <MarginLeft>200</MarginLeft>
        <AutoHeight>GrowAndShrink</AutoHeight>
        <Text>The Field object has a RunningSum property that makes is easy to maintain running sums over groups or over the entire report.
To keep running sums over pages, you need to use script. This report uses a field called "pageSum" which is updated in the OnPage and OnPrint events.</Text>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>Field2</Name>
        <Border>
          <Left>
            <Style>Solid</Style>
            <Width>15</Width>
          </Left>
          <Top>
            <Style>Solid</Style>
            <Width>15</Width>
          </Top>
          <Right>
            <Style>Solid</Style>
            <Width>15</Width>
          </Right>
          <Bottom>
            <Style>Solid</Style>
            <Width>15</Width>
          </Bottom>
        </Border>
        <Section>PageFooter</Section>
        <Left>0</Left>
        <Top>450</Top>
        <Width>9345</Width>
        <Height>30</Height>
        <Shape type="LineShape" />
      </Field>
      <Field>
        <Name>Field3</Name>
        <Border>
          <Left>
            <Style>Solid</Style>
            <Width>30</Width>
            <Color>FFC00000</Color>
          </Left>
          <Top>
            <Style>Solid</Style>
            <Width>30</Width>
            <Color>FFC00000</Color>
          </Top>
          <Right>
            <Style>Solid</Style>
            <Width>30</Width>
            <Color>FFC00000</Color>
          </Right>
          <Bottom>
            <Style>Solid</Style>
            <Width>30</Width>
            <Color>FFC00000</Color>
          </Bottom>
        </Border>
        <Section>Header</Section>
        <Left>0</Left>
        <Top>1800</Top>
        <Width>9195</Width>
        <Height>90</Height>
        <ForeColor>FFC00000</ForeColor>
        <Shape type="LineShape" />
      </Field>
      <Field>
        <Name>Field4</Name>
        <Section>Header</Section>
        <Left>5460</Left>
        <Top>1290</Top>
        <Width>1545</Width>
        <Height>315</Height>
        <Text>Today</Text>
        <Align>RightTop</Align>
        <ForeColor>FFC00000</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft1</Name>
        <Section>Header</Section>
        <Left>7050</Left>
        <Top>1290</Top>
        <Width>2160</Width>
        <Height>300</Height>
        <Text>Now()</Text>
        <Calculated>true</Calculated>
        <Align>LeftTop</Align>
        <ForeColor>FFC00000</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
          <GdiCharSet>1</GdiCharSet>
        </Font>
      </Field>
      <Field>
        <Name>Field5</Name>
        <Section>Header</Section>
        <Left>60</Left>
        <Top>30</Top>
        <Width>4065</Width>
        <Height>600</Height>
        <PictureScale>Scale</PictureScale>
        <Picture>
          <Image> </Image>
        </Picture>
      </Field>
    </Fields>
  </Report>
</Reports>