Sorting returned query data

  • Thread starter Thread starter Rob
  • Start date Start date
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
 
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)
 
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
 
Back
Top