Rounding and appending

[Tara]

I have a query that uses Int() to round down numbers. This works fine. The
problem is that this query then feeds a second query that just happens to be
an Update query. The rounded field is used in the Update query and instead
of keeping the rounding the way I need it, it goes back to standard rounding
rules. So, for example, in the first query the field "PayWeeks" may be
calculated at 1.888354, but thanks to the Int function, it rounds down to 1.
When I then use that field in my second query, the update query, it updates
the table to 2! Is there a way around this?

Thanks,

 

[Dale Fye]

Post the SQL you are using for the two queries.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Tara]

Sorry about not getting this posted right away Dale. I ended up leaving work
early yesterday. Anyway, here they are:

1st query:

SELECT tbl125.numIDNum, tbl125.dtmPlanStart AS StrtDt,
DateDiff("d",[StrtDt],[tbl125]![EndDate])/14 AS Weeks,
tbl125.ADJUSTEDStartDate AS StrtDtAdjusted,
DateDiff("d",[StrtDtAdjusted],[tbl125]![EndDate])/14 AS PayWeeksAdjusted,
DateDiff("d",[StrtDt],[TblDates]![EndDate])/14 AS PayWeeks, Int([PayWeeks])
AS PayWeeks2
FROM tbl125, TblDates;

2nd query:

UPDATE qryWeeks INNER JOIN tblWeeks ON qryWeeks.numIDNum = tblWeeks.numIDNum
SET tblWeeks.Weeks = [qryWeeks]![Weeks], tblWeeks.PayWeeksAdjusted =
[qryWeeks]![PayWeeksAdjusted], tblWeeks.PayWeeks = [qryWeeks]![PayWeeks2];


Thanks for any help!