employee review

[Guest]

I kow how to do the formulas in Excel to get the calculations I need but,
being unfamiliar with Access, I am not sure how to go about doing the same
thing. I want to set up a database of employees that keeps track of date of
hire, date of promotion, date of 30 day, 90 day, and annual review. I do not
know what functions in access will do the IF function in excel.

Any help/guidance anyone can offer will be appreciated.

Thanks in advance

 

[Douglas J Steele]

In a query, use IIf to provide the same functionality as Excel's IF.

 

[John Vinson]

I kow how to do the formulas in Excel to get the calculations I need but,
being unfamiliar with Access, I am not sure how to go about doing the same
thing. I want to set up a database of employees that keeps track of date of
hire, date of promotion, date of 30 day, 90 day, and annual review. I do not
know what functions in access will do the IF function in excel.

Any help/guidance anyone can offer will be appreciated.

Thanks in advance

IIF() is probably the first solution, as Douglas suggests.

HOWEVER... be sure you don't try to implement spreadsheet
functionality in Access. Excel is a spreadsheet; Access is a
relational database, and they require *DIFFERENT* logic and designs.
Just for example, your tables should certainly NOT contain calculated
projected review dates - they should instead be calculated on the fly
in Queries.

John W. Vinson[MVP]