retrive yearly overview

Question

Now I have a windows form application, where I can insert and update (here I
have a search button) and delete information about members. I have two
tables in a single database, table one contains personal information, and a
distinct ID, whereas table two has also has distinct ID and year and amount
columns. I can for example add John Doe and his personal information plus ten years and the amount he has paid for ten years in the second table, all is ok up to this step.

I have one form where all this operation is taking place. My question is in what way I can
retrieve information about John Doe's subscriptions overview, for example by selecting
any year I want to display the amount he has paid? I have a search button in front of distinct ID text box where I can retrieve information about John Doe, but only the last entries from the second table, I mean the personal info values can easily manipulated, and that part is as the way it should be, but as the question arrives how to select a single year about John
Doe and view values for that particular year.