PDA

Click to See Complete Forum and Search --> : Differing Data Order


casox
Mar 8th, 2000, 12:59 AM
The order of the records in access 2000 is different than when I do a full query from an ado vb6.0. ex. a, b, c, d, e in access 2000 when systematically pulled through a databound ado control is a, b, c, e, d. Anybody know what causes this? Thanks.

casox

Clunietp
Mar 8th, 2000, 12:43 PM
Someone asked this a month or two ago and got all bent out of shape because nobody knew....I just told him to use an ORDER BY clause at the end of his SQL statement and all would be ok, but he resisted again....