How to round down

[Mike Kampff]

I'm sure this is really simple, but I'm stuck.

Here is one of the fields in my query

 

[Brian Camire]

You might use the Int() function, as in:

Tenure: Int(DateDiff("d",[HireDate],Date())/365)

 

[John Spencer (MVP)]

Or use the integer division operator (the reverse slash)
364\365 = 0
365\365 =1
366\365 = 1

You might use the Int() function, as in:

Tenure: Int(DateDiff("d",[HireDate],Date())/365)

I'm sure this is really simple, but I'm stuck.

Here is one of the fields in my query
-------------------
Tenure: DateDiff("d",[HireDate],Date())/365
-------------------
How do I drop the decimal places off the result? I don't
want it to round up, just drop the decimals.

Thanks