creating column headers -
06-09-2004
, 05:40 PM
I have a database which has a start date field based on this date I
would like to have a query create a column name based on the year of
that date for the next three years. I can do it using headers of y1,
y2 and y3 and calculating the year(start_date) and adding
appropriately. My preference would be to have the expression calculate
the year and then put a value in that column. Hope this is clear and
thanks for any assistance. |