modifying Select statements to create a subtotal of items selected
Rendell Requiro
rendell@agbus.com
Wed, 29 Aug 2001 08:09:31 -0700
This is a multi-part message in MIME format.
------=_NextPart_000_0013_01C13061.EEBCDC00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello,
Anyone have experience modifying the default SELECT procedure to create =
a subtotal based upon the field(s) SELECTED with SELECT verbs? Try =
saying that three times quickly. I would like to create a total amount =
at the bottom of the screen that totals values for only the selected =
records. If there is no selection, my WHILE RETRIEVING of an alias of =
the file works just fine.
Thank you.
Rendell Requiro
AG Business Management, Inc.
rendell@agbus.com
831-455-2355 x101 voice
831-455-2264 fax
www.agbus.com
------=_NextPart_000_0013_01C13061.EEBCDC00
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2614.3401" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>
<DIV><FONT size=3D2>Hello,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Anyone have experience modifying the default SELECT =
procedure=20
to create a subtotal based upon the field(s) SELECTED with SELECT =
verbs? =20
Try saying that three times quickly. I would like to create a =
total amount=20
at the bottom of the screen that totals values for only the selected=20
records. If there is no selection, my WHILE RETRIEVING of an alias =
of the=20
file works just fine.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Thank you.</FONT></DIV>
<DIV><FONT size=3D2>Rendell Requiro<BR>AG Business Management, =
Inc.<BR><A=20
href=3D"mailto:rendell@agbus.com">rendell@agbus.com</A><BR>831-455-2355&n=
bsp; =20
x101 =20
voice<BR>831-455-2264 &nbs=
p; =20
fax<BR><A=20
href=3D"http://www.agbus.com">www.agbus.com</A><BR></FONT></DIV></FONT></=
DIV></BODY></HTML>
------=_NextPart_000_0013_01C13061.EEBCDC00--