Currently I have a field that is of type DateTime and it normally returns a result in queries like: 08/05/2004 18:20:05 I'd like to instead get back: 8/5/04 6:20 PM How can I do that in my query? Or am I forced to set up method fields for this? Ken Ray Sons of Thunder Software Web site: http://www.sonsothunder.com/ Email: kray at sonsothunder.com