Gossamer Forum
Home : General : Databases and SQL :

Sql Sort " ORDER BY " not working

Quote Reply
Sql Sort " ORDER BY " not working
i am using sql queries on an access database using VBA code. But the "ORDER BY " sort is not working. This is the line of code

" SELECT [sqft] FROM [chart_Max] WHERE Time BETWEEN " & first_day_max & " AND " & first_day_max + 0.999999 & " ORDER BY Time ASC"



It seems that the sort never works when used with VBA .Do you have any idea y this is not working. Do i have to add anything else? I am a newbie in this area . So it would be great if you could help me .

vimal
Subject Author Views Date
Thread Sql Sort " ORDER BY " not working vimaljohn 8979 Oct 24, 2002, 8:18 AM
Post Re: [vimaljohn] Sql Sort " ORDER BY " not working
yogi 8768 Oct 24, 2002, 9:10 AM