Order by or ?

Results 1 to 2 of 2

Thread: Order by or ?

  1. #1
    Join Date
    Dec 1969

    Default Order by or ?

    Can't remember this for the life of me. Pulling fields from an Access db and order by more than 1 field? First by date field and then by time field. As I recall there is a non-array way to do this called ordinal property???

  2. #2
    Join Date
    Dec 1969

    Default RE: Order by or ?

    &#062;order by more than 1 field<BR><BR>if i understand you right, just do this:<BR><BR>select &#060;fields&#062;<BR>from &#060;table&#062;<BR>where &#060;condition&#062;<BR>order by &#060;datefield&#062;, &#060;timefield&#062;

Posting Permissions

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