I am trying to make an if statement based on 3 fields being the same between the two tables. If all the criteria matches then information from KPMONTH_ID Table B is transferred to KFMONTH_ID Table A but it's not working. Any thoughts?

If ( TableA_Month = TableB::TB_Month and TACode = TableB::TBCode and TableA_Year = TableB::TB_Year; TableB::KFMonth_ID ; "Find Month ID")

Basically I am trying to automate transferring data from an excel file into my data base. I have my Months as a separate table from the days as they address different information. I need to track Months separate from days. Based on this I created two tables. Maybe this is over kill and Days and Months should be in the same table?

What - if any - is the relationship between the two tables?

Maybe this is over kill and Days and Months should be in the same table?

Hard to tell without knowing what are you trying to accomplish. In general, a table of months and/or days is redundant, since it carries no new information (we all know the calendar). The only item of interest is a table of events.

Gave up on the if statement and instead made a custom ID number based on a combination of fields.

This gave me the link I needed to join the two tables based on the imported information.