Adding a column

  • Thread starter Thread starter scuba
  • Start date Start date
S

scuba

I recognize this would be easiest done in Excel but I only have version 2003
and the data is too big to fit in Excel. I have a list of businesses and the
year they were established. I'm trying to calculate a column that will tell
me how many years they have been in business. So, a column has the start
date 1999, and i would like a column that basically takes 2008-1999 and
returns 9. I'm sure there is an easy way for this but what can I say, I'm
new to Access. Thanks for any help.
 
This is usually done using a calculated control. Assuming you have a text
box on your form that shows the start year, you can use the Control Source
property of this new text box to calculate it:
=Year(Date()) - txtStartYear
 
Back
Top