Hi all!



Thanks very much for your help! It's greatly appreciated!

I deleted the calculated fields in the table and created a new query as input into the form. I placed the calculated fields into the query using the formulae that you helped me with. Then I added some conditional formatting onto those fields so they would display in different colors when "Approaching" and "Not Approved" were found.

I learned a lot from doing this little project. Thank you again for all of your time and efforts; you made my day. I wish I had your knowledge of Access and relational databases. I was very frustrated for a while. I'll mark this as solved.