Results 1 to 3 of 3

Thread: Sort Data Report

  1. Jan 6th, 2001, 01:47 PM #1
    jrb187
    jrb187 is offline

    Thread Starter
    Member
    Join Date
    Oct 2000
    Posts
    34
    OK I've managed to create a DataReport thru
    the vb program and it works great but how do
    I get it to sort my records by LastName
    ascending. I've tried to find info on SQL,
    and have had some responses but where do I
    put the code:
    "SELECT*FROM members ORDER BY LastName"
    or is there another way to sort these records
    to show up on my report in the order I want.
    I'm using Access97 db with vb6.
    Thanks,
    newvbr
    Reply With Quote Reply With Quote
  2. Jan 6th, 2001, 01:50 PM #2
    parksie
    parksie is offline
    Monday Morning Lunatic parksie's Avatar
    Join Date
    Mar 2000
    Location
    Mashin' on the motorway
    Posts
    8,169
    If it needs a RecordSource or similar, use that code.
    I refuse to tie my hands behind my back and hear somebody say "Bend Over, Boy, Because You Have It Coming To You".
    -- Linus Torvalds
    Reply With Quote Reply With Quote
  3. Sep 17th, 2003, 06:20 PM #3
    tomjess
    tomjess is offline
    Hyperactive Member tomjess's Avatar
    Join Date
    Mar 2001
    Location
    Hamilton, New Zealand
    Posts
    348

    jrb187

    I am looking at the same right now.

    Where did you put that line of SQL?

    Thanks
    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