Formula reqd

  widdy 16:22 PM 03 Jan 13
Locked

I would like to insert a field in an access database that will calculate hyow long a person has been a member of a club. i.e. calculate from their joining date (in one column) to current date in years and days Heres Hoping Thanks

  wiz-king 16:40 PM 03 Jan 13

Just take one from the other (cells formated as date) format the result as number and it will give the answer in days

Advertisement

This thread is now locked and can not be replied to.

OnePlus 2 UK release date, price, specification rumours: We're just hours away from the OnePlus 2 l2…

Why Vodafone’s frequency choice should interest you: The benefits of 800MHz

Motoman robots: from killing The Terminator to samurai swordmanship

Why Apple's being criticised for everything, even the good things