Rounding Up

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
R

Robin Chapple

I use a calculation to determine how long a member has been a member
of a club:

Years: DateDiff("yyyy",[datejoined],Now())

Is there a way to show the number of years at the next anniversary?

The interntion being the a report printed in October would show

John Smith - joined 1st November 2000 - been a member for 4 years.

Thanks,

Robin Chapple.
 
Are you saying that you want to know how long they've been a member as of a
specific date, or specifically their anniversary date?

If the former, take a look at
http://www.mvps.org/access/datetime/date0001.htm at "The Access Web". While
it's talking about calculating age, anniversaries are the same. You can
substitute your specific date for Now() in the equation.

If what you want is related to each member's anniversary date, try:

Years: DateDiff("yyyy", [datejoined], DateSerial(Year(Date()),
Month([datejoined]), Day([datejoined]))
 
Back
Top