Recent content by slimjeanyves

Thank you for this! I got it running with your suggested code in a Select query, however I cannot for the life of me figure out how to do this with an update query. Here's my code: "UPDATE [tbl_Multi_Q_2012-2013 Query] SET [Field1]"="Q" & DatePart([qq],[tbl_Multi_Q_2012-2013]![Date]) &...

I have a Date field in the format X/XX/2012 for all my records. I want to create a field that labels each record according to its quarter. So if a date is 3/29/2012, I'd want the corresponding field entry to be: Q1 2012. If it's 3/29/2013, I'd want it to be: Q1 2013, etc. I guess I would run...