Thank you so much for your help! I need to go through it bit by bit to understand how you're making it work, but it does work!

Amazingly, I think I may have been able to change your code to get the correct results. Is this syntax correct?

DECLARE @fiscal_year INT

SET @fiscal_year = 2015

DECLARE @fiscal_period INT

SET @fiscal_period...

Thanks to both of you for taking the time to help!

It occurred to me I forgot about one major thing. The fiscal year starts in the previous calendar year....

Thank you all for your help. I think I will create another table to store these codes. I'm waiting to hear back from the vendor to make sure...

VBA is beyond me, unfortunately, so trying to figure that out may be harder than just doing what I'm doing, but I thank you very much for your suggestions! ...