Results 1 to 3 of 3

Thread: SQL and ORDER BY *SOLVED*

Threaded View

  1. Jul 28th, 2003, 08:23 PM #1
    lintz
    lintz is offline

    Thread Starter
    PowerPoster lintz's Avatar
    Join Date
    Mar 2003
    Location
    The 19th Hole
    Posts
    2,697

    Question SQL and ORDER BY *SOLVED*

    There is probably a simple answer to this but I can't work it out. I've got a query that I need to sort the Dates found by ASC order but I keep getting errors. The query ran perfect until I tried to add the ORDER BY part. Can someone help me out.

    Thanks.

    Code:
    sSQL = "Select * from Party WHERE [Date Of Party] BETWEEN " & CLng(DTPicker1.Value) & " AND " & CLng(DTPicker2.Value) ORDER BY [Date Of Party]
    Last edited by lintz; Jul 28th, 2003 at 08:36 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width