Thanks Alan, I figured I was all over the place...
I guess my first question would be how do I set up a formula in access... I understand I have to create a query, this is the formula I have currently in excel
=IF(IFERROR(D2-TODAY(),0)=0,"TBD",D2-TODAY())
D2 being another column in access...