Report question (1 Viewer)

[malberty]

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

 

[KevinM]

In an expression in a query put....

Year([NameOfField)

hth