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
" 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