> -----Original Message-----
> From: s.beames@... [mailto:s.beames@...]
> Sent: Thursday, August 02, 2001 5:26 PM

...

> I've finally gotten a selectable SP syntax that works for my report,
> but it looks rather wordy to me! For my own edification, could
> someone more experienced please advise if there a neater way of doing
> this? I wanted one line per account showing the total charge for some
> period.

You should be able to do it in a single select statement, which goes:

Select ACCNT_ID, SUM(CHARGE)
From JOBS
Where COMPLETED between :startDate and :endDate
Group By ACCNT_ID


Sean