Convert a date into quarters

[adray13]

Hi!



I am fairly new to Access and have tried researching the answer to this question with no luck. I have a "Move Date" column that I would like to keep in the query, but just add a new column converting that date into quarters. I tried entering the excel formula I know into the "field" box under design view, but I am getting an error that says it can't match something in the "criteria" field.

For the formula (=INT((MONTH("Move Date")-1)/3)+1 &"Q"&" " & YEAR("Move Date")) I just replaced where the specific would go with"Move Date" which is the field name of the column with the date. Not sure if that was right... Obviously not if I am getting an error.

Thank you for any help!

[alansidman]

A similar situation earlier today.

https://www.accessforums.net/queries...ery-30497.html