Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    NEED DYNAMIC QUERY & REPORT

    NEED DYNAMIC QUERY & REPORT

    Using Access 2000 (9.0.4402) SR-1

    I have a report that prints the following data from a query:

    Date Code Description Amount
    06/01/01 101 Smith, John 5.00
    06/01/01 102 Blow, Joe 10.00
    06/01/01 103 Jones, Tom 15.00
    06/02/01 102 Blow, Joe 10.00
    06/02/01 103 Jones, Tom 15.00

    The operator would start the report from a criteria form that would allow her to select the report sequence.

    Enter Report Sequence:

    Date (Sort by Date, Code, Description)
    Code (Sort by Code, Date, Description)
    Description (Sort by Description, Date, Code)
    Amount (Sort by Amount, Description, Date)

    To reuse as many objects as possible, I would like to only have 1 query and 1 report to accomplish the above.

    How do I pass the sort variables from the form to the query that accomplishes the sort?

    How do I pass the sort variables from the form to the report to print sort variable in the header?

    I

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: NEED DYNAMIC QUERY & REPORT

    See my reply in <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=acc&Number=44073&page=0&vie w=collapsed&sb=5>this post</A>
    Charlotte

Posting Permissions

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