Recent content by parrothead517

So I would put Format([Effective_Date],"mm/dd/yyyy") in the Criteria under that Field??? I tried that and still got the time. Is there an easier way to just turn it off? I have a new table every day that I already have to copy to reformat and this is another extra step. Boo on Access...

Thank you - I did read this, but as I said, I'm not very Access saavy. This statement alone reads like greek to me. :( Anything more specific you can provide would be great. I guess I'm baffled because I didn't have this issue in 2003, but do in 2007.

Need Date, but not Time in Exported Text File I have a table that I need to export to a text file without the time attached to the date. I have Export Specs that I assign to the file when exporting it and when it shows me how it will look, there is no time. BUT low & behold, when I open the...