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.

14 best budget laptops of 2015: best budget laptops reviews - best cheap laptops - best bargain…

1995-2015: How technology has changed the world in 20 years

Animated film of Raymond Briggs' Ethel and Ernest ramps up production

From Antennagate to Yellowgate: The 10 worst Apple scandals (and why they were blown out of proport)…