Recent content by Access77

Thanks, my field is not named date. I just used this in the example.

Thanks that did it!

I am getting the error message 'The expression cannot be used in a calculated column', though I think you are close. I have tried variations of this, but so far without success.

I am creating the Access expression builder to create a field in a table, drawing from other fields in the same table. I have an existing date field in the table that has the format dd/mm/yy. I want to get the month from this existing date field. The expression I am using is: &...