Hi,
I have a column that has data that looks like this:
5/19/1999
6/4/1998
11/4/2001
12/13/2005
I would like to write an update query that would insert only the month and the year in a new column called PostMMYYYY. The new column would have these values:
51999
61998
112001
122005
Please help(MS Access 2003).
Thanks
Mo
Mo
I have a column that has data that looks like this:
5/19/1999
6/4/1998
11/4/2001
12/13/2005
I would like to write an update query that would insert only the month and the year in a new column called PostMMYYYY. The new column would have these values:
51999
61998
112001
122005
Please help(MS Access 2003).
Thanks
Mo
Mo