rounding down

[markcranmer]

Hi all,



I want to replicate the following Excel formula in an Access query:


=ROUNDDOWN((MAILING_DATE-PURCHASE_DATE)/365,0) Number of years


The closest I've got is:

appliance age: Round(([Mailing Date]-[PURCHDATE])/365,0)

but as you can see, the expression doesn't round 'down'.

I have attempted to implement a Int(100 * [MyField]) / 100 type approach, but the results don't tally with the Excel results.

Many thanks,

Mark

[RuralGuy]

And what do you get with Int(([Mailing Date]-[PURCHDATE])/365)