Gossamer Forum: General: Databases and SQL: Sql Sort " ORDER BY " not working (vimaljohn)

Gossamer Threads

Home : General : Databases and SQL :

Sql Sort " ORDER BY " not working

Oct 24, 2002, 8:18 AM

vimaljohn

New User (0 posts)

Oct 24, 2002, 8:18 AM

Shortcut

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
Sql Sort " ORDER BY " not working	vimaljohn	11760	Oct 24, 2002, 8:18 AM

Re: [vimaljohn] Sql Sort " ORDER BY " not working	yogi	11398	Oct 24, 2002, 9:10 AM

Gossamer Threads is a Vancouver-based company with over 28 years experience in web technology. From development to hosting, we partner with leading organizations around the globe and help to build their web presences, strategies and infrastructures.

Let’s talk: 1-877-715-7676