Re: Problems with decimal numbers

2005-02-09 Thread DanielWalker
On Tuesday 08 February 2005 21:11, Stephane Pinel wrote: > Hello, > > When I try to insert decimal numbers like 12857.59, 13858.58 or > 14785.60, they are inserted as 12857.58, 13858.57 and 14785.59 ?! > > DataType is DECIMAL 10,2 > > Any idea of a way to avoid this annoying issue ? > > Thanks. > >

Re: Query problem

2005-02-09 Thread DanielWalker
On Tuesday 08 February 2005 17:03, Coz Web wrote: > > This will (as I believe Daniel suggested) keep things relatively > simple, avoiding an overly complex query that you cannot maintain in > the future. Well, my solution was, as you'll have observed, vastly over-complicated. I think I'd misunder