I have a table of product data that is returned from a linked Access query.
One of the columns contains a date. I create a calculated column headed
1-Jan-2005, and then 1-Feb-2005, etc all the way to now
I then try to create a simple IF statement that would compare the column
header with the date column in the table and return a Over or Not
dependending on whether the data in tha table is greater that the column
header.

=IF(Table_CBCC_Data[[#This
Row],[dateBudget]]Table_CBCC_Data[[#Headers],[01-Jan-05]],"Over","Not")

Now the formula is carried down to all the rows in the table but the
calculated result is always the value in the first cell irrespective of
whether the test is true or not in the rest of the cells. What am I missing
here? Is there a special way of generating calculated formulae in this
fashion?