Search results

  1. Z

    Common parameters for multiple queries

    I have several queries which use the same parameter. The parameter is updated once in a while. To avoid having to change the parameter for all the queries, I have thought of two solutions, but have not executed. 1. Define a "global constant" to store the value, and every time I want to...
  2. Z

    Showing page header of the sub reports

    I would like to combine several reports into one report. Therefore, I created a main unbound report and move the sub reports to the "Report Header" section of the main report. The detail section of the sub report shows fine, but the page header and page foot header sections of the sub report...
  3. Z

    Multline setting in a memo field.

    I work with Access 2003. I created a form on a table using wizard. There is a memo field. I'd like to be able to enter multiple lines in the field. However, when I press "enter" it goes to the next field. What properties can I change in the table and/or the form to be able to enter multiple...
  4. Z

    Formatting Issue with Query

    I made a query (and its pivot table view) and would like the numbers to be in certain format. I could format the underlying table but not the query itself. 1. Is there any way to format it? 2. if not, may be the query is not the best place to format data, do I have to do it in forms and...
Back
Top Bottom