Results 1 to 4 of 4

Thread: Report Rows

  1. #1
    Join Date
    Nov 2005
    Posts
    79

    Unanswered: Report Rows

    I have created a report/form in MS Access. The form looks like it can hold about 11 rows of information. At times I may have less than 11 rows. If I have 5 rows, how can I make the report print another 6 blank rows?

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Just an idea (may not be what others would do but what I could think of quickly)

    Make a temp table.
    Put in 11 blank rows.

    Then In your button to show the report, have it run an update query to first update the query with blank values again (so it clears the values in the temp table) and then update the temp table with the values from your data table. Have the report based on the temp table.

    Scratch that....I'll try to think of something else....nice new fresh puzzle.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926

    Example

    Here's an example (done very quickly). Again, there's probably another way to do this (and probably easier.)
    Attached Files Attached Files
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  4. #4
    Join Date
    Nov 2005
    Posts
    79
    Thank you very much, it worked like a charm

Posting Permissions

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