I assume this question comes up a lot. How do I format calculated fields in a query. Sometimes the property sheet on the right allows format. Other times it doesn't display anything. Is there a reference to a tutorial that can teach me the various ways to form in the calculation expression that I do or VBA. I have a couple of fields that doesn't display as I want it to.