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 .

Quote Reply
Re: [vimaljohn] Sql Sort " ORDER BY " not working In reply to
I moved the post to a more appropriate forum.

Iyengar Yoga Resources / GT Plugins