Craig said
> I'm not an SQL expert, but couldn't you first get the grand total as a
> variable (unsure whether it would be best to do a preliminary query to
> retrieve the single total or sum the total of the column in of your
> current resultset - someone may be able to comment here).
Yeah, Craig, it was that second option that I was really getting at.
Since there have been no other posts on this, I'll assume its not possible
(or that I have failed to adequately define the problem ;-)
Mark
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
