Except in very special circumstances, you SHOULD NOT add the calculated
value to the table. If you can calculate it on a form, you can calculate it
in a query or report just as well.
I just need to write a query based on a date and add one year to the
parameter. For example if the customer adds the date 01/01/05 I wish the
query to return records for 01/01/06. Any ideas?