Results 1 to 2 of 2

Thread: Access Reporting Function

  1. Jun 18th, 2001, 01:12 AM #1
    Relg
    Relg is offline

    Thread Starter
    New Member Relg's Avatar
    Join Date
    Apr 2001
    Location
    Sydney, Australia
    Posts
    8

    Unhappy Access Reporting Function

    Hey All

    I would lik to increase the flexibility of the reports in my access 2000 db. I have several reports which would be useful to sort by different fields. Is there anyway of changing the sql string at runtime, either from a form which opens a report, or from the report itself, in order to change the sort order on the form???


    ive tried some vb code which tries sets the records source, however it doesnt seem to like it.

    Thanks

    Relg
    Reply With Quote Reply With Quote
  2. Jun 18th, 2001, 06:11 AM #2
    Gaffer
    Gaffer is offline
    Fanatic Member Gaffer's Avatar
    Join Date
    Nov 2000
    Location
    London
    Posts
    828
    How about rptMyReport.OrderBy = 'MyField' ?
    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