Breaking Date Fields Apart

I have a date field in an access table which I need to split into 2 fields one for month and one for year to allow me to group by the month and year.

I have checked in mysql book and a couple of features such as DATENAME and EXTRACT(MONTH from FIELD) are suggested however these are not recognised in MSACCESS.

I would be grateful for some suggestions on other options.

Thanks

Stephen.

Try using help and enter "date format" you will find the answer there in the example.

I have also attached a sample db you may find helpful.


Regards,

You could try using the SQL string functions LEFT$(filedname,len_from_start), MID$(fieldname, startpos, len) and RIGHT$(fieldname,len_from_end)