How do I return value based on row and column location

[jseverado]

Hi all,
I have searched hi and low for this solution and I cant find it. so here goes. I inherited a spreadsheet that uses an Index(Match formulate to return a value. I want to use Access to manage the data going forward. I am just starting to build my tables in Access so I have some flexibility and want to do it right. Here is a sample of the data:

Key Enroll Jan Feb Mar Apr May
abc 1/2013 10 3 5 2 1
def 3/2013 0 0 7 8 9
ghi 5/2013 0 0 0 0 8


So if Enroll date starts in Jan I want the 10 amt returned from the Jan column. If the Enroll date starts in March, for that client I want the March amy returned, etc.

results: for client "DEF" the amt returned should be "7" because their enrollment date is 3/2013.

One important thing to note: I do not know VBA language or SQL language, not that I cant cut and past. Just wanted you to know that I only know how to use the Query wizard or builder to do stuff.

I hope someone out there knows how to do this. Help please!!

 

[jseverado]

Pat, thank you soooo much, that was such a big help. one more question. how do I tie the RecID from tbl1 to tbl2? Do I need to join the table using the old PK?

 

[tamangspace]

jseverado,
I learned PK and FK from this link. It is better to read it will help you more.
http://rogersaccessblog.blogspot.com/2008/12/what-is-primary-key.html

Best of Luck