Hi Helen,
Thanks for the help but i decided to just go the alternate route and
use a select stored procedure, if i come across the problem again
i'll let you know.

anth

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> At 01:39 AM 29/07/2003 +0000, you wrote:
>
> > >
> > > SELECT
> > > u.userkey,
> > > SUM(U.PAYTOTAL) AS TOTAL
> > > FROM MBUSERPAYMENT U
> > > LEFT JOIN MBPAYMENT P ON P.PAYMENTKEY=U.PAYMENTKEY
> > > LEFT JOIN MBPAYMENTDATA D ON D.PAYMENTKEY=P.PAYMENTKEY
> > >
> > > where D.PROVIDERITEMKEY=:pkey
> > > AND P.STATUS=1
> > > AND D.PAYFORYEAR=2003 AND
> > > D.PAYFORMONTH=5
> > >
> > > group by u.userkey
> > > having U.USERKEY=:ukey
> > >
> > > That's about all I can come up with...try it and see whether it
> >works.
> > >
> > > Helen
> >
> >
> >Hi Helen,
> >Unfortunately no luck with that or any other variation of SQL I
can
> >think of, the strange thing is that if I run the same SQL in the
> >IB_SQL console or Interbase PlanAnalyser the correct '-0.04'
result
> >is shown. Also results with 2 decimal places where the 2 digits
are
> >greater than zero, e.g. '-0.17' appears fine as well so its as
> >though the minus in '.-4' is being put in the zeros place if the
> >first decimal place is zero.
> >I'll email you a small sample program if you'd like, but i run
bcb6
> >not delphi.
>
> I don't have BCB at all.
>
> Some things to look at if you haven't already...
>
> Do you have anything at all in the FieldsDisplayFormat and/or
EditMask
> properties of the column?
>
> What does the query look like in the monitor when it's prepared?
>
> Are you by some accident trying to connect the IB_Edit/FastReport
with a
> TDatasource and/or TIBOQuery?
>
> Helen