<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6396.0">
<TITLE>How to Create Running Totals in a Query</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">Cross-posted to Access-L and AccessD lists for their archives.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">M$ posted KB article 290136 on above subject showing two methods of using the DSum() function.</FONT>
</P>
<P><B><FONT COLOR="#0000FF" FACE="Arial">Charles Wortz</FONT></B>
<BR><FONT COLOR="#0000FF" FACE="Arial">Software Development Division</FONT>
<BR><FONT COLOR="#0000FF" FACE="Arial">Texas Education Agency</FONT>
<BR><FONT COLOR="#0000FF" FACE="Arial">1701 N. Congress Ave</FONT>
<BR><FONT COLOR="#0000FF" FACE="Arial">Austin, TX 78701-1494</FONT>
<BR><FONT COLOR="#0000FF" FACE="Arial">512-463-9493</FONT>
<BR><FONT COLOR="#0000FF" FACE="Arial">CWortz@tea.state.tx.us</FONT>
</P>
<BR>
</BODY>
</HTML>