As I understand the problem
You paste unsorted values from excel to Access and after they are pasted although the view is unsorted they appear sorted in Access?
Check the Reference column before you paste in your view. The option may be enabled.
The following SQL statement keeps generating the syntax error below:
<%SQL= " select tblProducts, tblCustomer, tblProductType, tblPricing, tblOrder, tblOrderDetails where tblProductType.ProductTypeID=tblProducts.ProductTypeID and tblProducts.PriceID=tblPricing.PriceID and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.