Guest_imported
New member
- Jan 1, 1970
- 0
I use a query to increase values in a table by 2.5%. Is it possible to round these values (up or down)in the same query??
Thanks,
Martin.
Thanks,
Martin.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Rounding values in queries
- Thread starter Guest_imported
- Start date
- Status
It may depend on which version of Paradox, but certainly, in DOS, you are limited to the amount of Math functions that can be used in a query (eg INT, ROUND can not be used).
So I can't come up with a method of doing this in a query. I tend to use a SCAN loop and do each record in turn.
SCAN
[Number Field] = INT([Number Field]+.5)
ENDSCAN
or a more complex text if you want.
7.2+.5 = 7.7 = 7
7.5+.5 = 8.0 = 8
8.0+.5 = 8.5 = 8
Phil
So I can't come up with a method of doing this in a query. I tend to use a SCAN loop and do each record in turn.
SCAN
[Number Field] = INT([Number Field]+.5)
ENDSCAN
or a more complex text if you want.
7.2+.5 = 7.7 = 7
7.5+.5 = 8.0 = 8
8.0+.5 = 8.5 = 8
Phil
- Status
Similar threads
- Locked
- Question