Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Location
    California
    Posts
    502

    Unanswered: Justify field data in query pane & dynaset?

    In the query pane window there doesn't seem to be way to left, right, or center the results in the fields.

    No suprise, I can't seem to find that the dynaset either.

    Also, Column Headers in queries and dynaset.

    What I would like in lieu of TOTAL TRANSACTIONS

    would be

    TOTAL
    TRANSACTIONS

    Any idea on how to accomplish that?

    Thanks . . . Rick

    please don't hurt me . . .

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    query pane windows are not meant to be used for displaying data in a report format, use a report. If you need to be able to edit data, consider wrapping your query up in a form and simulating the "spreadsheet" feel, if that is indeed what you are after.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Mar 2004
    Location
    California
    Posts
    502

    Page Header . . .

    Thanks Teddy, I placed a query that performs calculations in a report footer. It works!

    Is there a better way to display the dynaset than just placing the results in a report footer which will allow me to make the center text, etc., formatting?

    Thanks . . . Rick

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    No. There is a distinct seperation between your data, and how you present your data. "dynaset" refers to a dataset, or pure data. You use reports to define text formatting and such in order to present the "dynaset" in a way that is meaningful to you or your users.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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