Access Not Exported Most Recent Query Data?

A

Al Franz

Having a problem using Access 2007. I create a query, run it and then
save/export the data to a TXT file, without formatting. Not using the
formatting since the queries are returning lots of data and it is the only
way Access will work. I then modify the query, run it, get new results and
do a save/export and it is saving the data from the first query run? Is
there something that needs to be reset. Or do I have to create a new query
from scratch all the time to make this work properly?
 
P

pietlinden

Having a problem using Access 2007.  I create a query, run it and then
save/export the data to a TXT file, without formatting.  Not using the
formatting since the queries are returning lots of data and it is the only
way Access will work.  I then modify the query, run it, get new resultsand
do a save/export and it is saving the data from the first query run?  Is
there something that needs to be reset.  Or do I have to create a new query
from scratch all the time to make this work properly?

make sure you save the changes to the query first, then export. It's
probably running the saved querydef.
 

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

Top