Hi
I am trying to write an update query which will return a value within a new table, based on a date in my import table.
The date format is dd/mm/yyyy and I want to return the month in another column (ie 01 to 12).
To complicate matters, I want to return a value based on some additional...