Report question

  • Thread starter Thread starter malberty
  • Start date Start date
M

malberty

Guest
I'm trying to create a report where I'm sorting by location, an activity, and the year the activity was preformed. The information was entered into the database for the date field as follows 5/7/1999. I only want to extract the year like 1999. How do I do this
 
In an expression in a query put....

Year([NameOfField)

hth
 

Users who are viewing this thread

Back
Top Bottom