I am new to Access 2007, a former FileMaker Pro database user.

I am trying to replicate some functionality that was available in the FM DB, which involved Calculated Fields in one of the Tables.

The Calculation would evaluate the dates in some of the other fields in the table and return a numerical result. Filemaker used a Case calculation.

I need to replicate this functionality in my new Access 2007 DB...