Sorting returned query data

R

Rob

Hi,

I am using data returned from an Access database in Excel and when ever I
use the Refresh icon, the data that returns from the database doesn't match
what's held in the database. If I create a new query and use Get External
Data command the correct data is returned.

Any ideas why data isn't returned as should be on clicking the Refresh icon.

Thanks, Rob
 
V

Van T. Dinh

Sound to me more of an Excel question since you perform this in Excel.
Access (JET actually) obviously provides correct data to your MS Query in
Excel.

Perhaps, you should re-post to one of the relevant Excel newsgroups.

HTH
Van T. Dinh
MVP (Access)
 
R

Rob

Van, thanks for advice. I reset the query and not had the issue again,
seems like it was caused by the sorting of data which was set as part of the
query.

Regards, Rob
 
Top