Results 1 to 13 of 13
  1. #1
    4 Star Lounger
    Join Date
    Oct 2002
    Location
    Sayre, Pennsylvania, USA
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report to look like Excel (2000)

    I have a report and I would like the output to look like a grid like you can in excel. Is there an easy way to do this? So far I haven't found one.
    Thanks,
    Deb

  2. #2
    2 Star Lounger
    Join Date
    Jun 2002
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report to look like Excel (2000)

    Try the Report wizard - AutoReport: Tabular based on a Crosstab query.

  3. #3
    4 Star Lounger
    Join Date
    Oct 2002
    Location
    Sayre, Pennsylvania, USA
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report to look like Excel (2000)

    Cross tab query doesn't give me what I want. I don't have the proper data to use it. Any other suggestions?
    Deb

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Report to look like Excel (2000)

    That kind of report doesn't have to use a Crosstab query as it's data source, but without more details, we can't make explicit suggestions.
    Wendell

  5. #5
    4 Star Lounger
    Join Date
    Oct 2002
    Location
    Sayre, Pennsylvania, USA
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report to look like Excel (2000)

    Basically I have a report that has columns and rows of data and I'd like to have grid lines between each column and row (like and excel spreadsheet). A snap shot is attached. The bottom section is where I'd like the grid
    Thanks
    Deb
    Attached Files Attached Files

  6. #6
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Report to look like Excel (2000)

    That should simply involve turning on the border for the text boxes that run across the detail section of the report - they are presumably set to transparent now.
    Wendell

  7. #7
    4 Star Lounger
    Join Date
    Oct 2002
    Location
    Sayre, Pennsylvania, USA
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report to look like Excel (2000)

    But that's assuming the fields touch each other which mine do not, so I'm assuming to get the grid I want I have to make them all touch each other. Thanks, Deb

  8. #8
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Report to look like Excel (2000)

    Yes, either that, or place rectangles over each text box, turn on their border, and send them to the back. The reason for doing that is that you may not like the data being directly against the border if it is right or left justified - but then you need to make sure your text boxes can't grow. Always a gottcha isn't there.
    Wendell

  9. #9
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Pennsylvania, USA
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report to look like Excel (2000)

    If I understand you correctly you want have grid lines around your report controls.
    threecrow

    Don't make excuses. It's what you do, not why you didn't.

  10. #10
    4 Star Lounger
    Join Date
    Oct 2002
    Location
    Sayre, Pennsylvania, USA
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report to look like Excel (2000)

    Yes I do John.
    Deb

  11. #11
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Pennsylvania, USA
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report to look like Excel (2000)

    Can you post the design report here or send direct I will set up

    it not pretty in design but it works
    threecrow

    Don't make excuses. It's what you do, not why you didn't.

  12. #12
    4 Star Lounger
    Join Date
    Oct 2002
    Location
    Sayre, Pennsylvania, USA
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report to look like Excel (2000)

    Is is different than what Wendell offered. I ended up putting rectangles around each field and that gives me what I want. What are you offering?
    Thanks,
    Deb

  13. #13
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Pennsylvania, USA
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report to look like Excel (2000)

    <P ID="edit" class=small>(Edited by ThreeCrow on 31-Aug-04 22:48. Edit by Threecrow Found better than my way to put grid lines on report)</P>If you have what you want, then all is done

    Helen Feddama
    Has method of this on her web site, after logging on goto Archon #104

    http://www.helenfeddema.com/access.htm
    threecrow

    Don&#39;t make excuses. It&#39;s what you do, not why you didn&#39;t.

Posting Permissions

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