Got on more question (I hope) about functions.

I have a table that contains a year (school year) and an End Status Code, I need to flag students that have the end status code of 45 in school year 2005.

When I use the below code the column popluates with "#ERROR".

IIf([ST010]![SCH_YR]="2005" And [ST010]![END_STAT]="45","Y","N")

Any Ideas?

Again thanks for the help..

--pete

You are treating "2005" and "45" as strings. Perhaps they are really numbers? In which case, leave off the quote marks.