Formula reqd

  widdy 16:22 03 Jan 2013
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 03 Jan 2013

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

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

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Best of the Grad Shows 2017: University of the West of England (UWE)

Best value Mac: Which is the best £1249 Mac to buy

Les meilleures GoPro 2017