Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Aug 2012
    Location
    Israel
    Posts
    25
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Substitute for Excel grid in access

    We are changing an official form from excel to access.
    The old form had a grid with 14 rows X 3 columns.
    Access reports do not need to "print" a grid at all but we want to keep the OLD LOOK.
    How can I fiddle with the access report to make a permanent grid with 14 rows in which only a few of them have data?
    Thank you.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Probably the simplest way would be to create a separate report table in Access that has 3 columns (fields) and has 14 records. Populate the temporary table using whatever process need to get the data you wish to report. Then base the report on the table, and display all the records. Be sure to turn on the gridlines so you get the box effect you would get from Excel.
    Wendell

Posting Permissions

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