::: URGENT...please...URGENT :::

Hi,

I have this WEIRD problem and I'm perhaps heading for trouble:

Access database, a field set to "Long Number".
In that field you must ONLY type in numbers, no commas etc. I use the field
as a weight field for a fishing competition.

If somebody catch this particular weight, the result is not shown right:
3444 g. Is that number a special number or what?

On the result page the results are sorted by most boat-points then number of
fish, then number of species and finally the weight.

If that "magic" number is there, that fisherman will be the winner - which
in this case - is not right. If I change his fish weight to 3441 for
example, there's no problem?????????

I simply CAN'T understand that, and tomorrow is my last day to figure out
the error - that's when the competition starts.....

........help.......

Helle :-(

this is the recordset - if anybody can see something here:

SELECT Q_PointTotalArt_Dag1.IDKonku, Q_PointTotalArt_Dag1.ID1,
Q_PointTotalArt_Dag1.U_NO, Q_PointTotalArt_Dag1.U_FIRST,
Q_PointTotalArt_Dag1.U_LAST, Q_PointTotalArt_Dag1.U_SEX, tbl_Sex.U_SEXLong,
Q_PointTotalArt_Dag1.Postnummer, Q_PointTotalArt_Dag1.Postdistrikt,
Q_PointTotalArt_Dag1.NationPix, Q_PointTotalArt_Dag1.KlubID,
Q_PointTotalArt_Dag1.KlubKort, Q_PointTotalArt_Dag1.BoatID,
Q_PointTotalArt_Dag1.Notat, Q_PointTotalArt_Dag1.Boat,
Q_PointTotalArt_Dag1.BoatPoint, Q_PointTotalArt_Dag1.Point,
Q_PointTotalArt_Dag1.FiskAntal, Q_PointTotalArt_Dag1.FiskArter,
Q_PointTotalArt_Dag1.FiskWeight, Q_ArtFangstMax.MaksOfFangstWeight,
Q_PointTotalArt_Dag1.PointKg, Q_PointTotalArt_Dag1.PointFisk,
Q_PointTotalArt_Dag1.PointArt, Q_PointTotalArt_Dag1.Total
FROM (Q_PointTotalArt_Dag1 INNER JOIN tbl_Sex ON Q_PointTotalArt_Dag1.U_SEX
= tbl_Sex.U_SEX) LEFT JOIN Q_ArtFangstMax ON Q_PointTotalArt_Dag1.ID1 =
Q_ArtFangstMax.ID1
WHERE (((Q_PointTotalArt_Dag1.IDKonku)=MMColParam) AND
((Q_PointTotalArt_Dag1.U_SEX) Like 'value2'))
ORDER BY Q_PointTotalArt_Dag1.BoatPoint DESC , Q_PointTotalArt_Dag1.Point
DESC , Q_PointTotalArt_Dag1.FiskAntal DESC , Q_PointTotalArt_Dag1.FiskArter
DESC , Q_PointTotalArt_Dag1.FiskWeight DESC ,
Q_ArtFangstMax.MaksOfFangstWeight DESC

I can't image that's a special number. It's pretty ordinary.

"Long Number" wasn't a field choice in my copy of Access. Is this an integer
data type? Perhaps you should try a decimal or floating point type, especially
if you want to get accurate with the weights and allow fractions.

Did you input the letter 'g' into this numeric type?
How was the data entered?
What is some of the other entered data?
Can we see a listing of a sample set of results?