var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Round down in a query
I am transfering some calculated fields from a form to a query.
I used to be able to round down the result of the calculation in VB by typing "int" before the calculation, which would round down, say 5.8, down to 5.
Using the 'Build' section in a design query, I cannot see how to round down the results. My 'build' currently looks like this...
Payments Outstanding: ([End Of Lease]-Now())/30.4375/[Finance Details]![Payment frequency]
Can anybody help?