date change

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table question that I cannot figure out. I have a date field in my
table. All the records have the field populated with the same
date...12/08/2004. I changed the date in the table to 11/01/2004....when I
open the table all the records have the 11/01 date and if I run a query they
all have the 11/01 date...but if I export that query to a text file....the
text file shows the orginal 12/8. How can I correct that on the table end?
thanks
 
Please provide the SQL statement your query uses.

How are you exporting the query?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dlookup 7
Access Running Balance in Access 1
Stored date is not being recognised 1
Using DateAdd and IIF conditions in a Query 2
Previous Month Date Function 5
Populate a table 2
Grouping monthly data 4
Period End Dates Table ... How to Link? 3

Back
Top