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
Quote Reply
Re: [vimaljohn] Sql Sort " ORDER BY " not working In reply to
I moved the post to a more appropriate forum.

Ivan
-----
Iyengar Yoga Resources / GT Plugins