On Wed, 9 Sep 2009 21:22:03 -0700, paduanow wrote:

Where do I put the Format command?

I'd use the Format *function* - not command - in whatever query you use to
export the data to the state's formatted file: you can just put

ExpDate: Format([datefield], "yyyymmdd")

in a vacant Field cell in the query, and then export this query.

Don't confuse data STORAGE with data PRESENTATION. They are different tasks!
--

John W. Vinson [MVP]