How can I convert a Date Field in to a String as follows: "YYYYMMDD"
J JJEWELL Dec 21, 2005 #3 Try this as a calculated field in your query New: Format([DATE],"yyyymmdd")
