Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2009
    Posts
    5

    Red face Unanswered: MS Access report design

    I have designed a report in Access 2007 that shows table data in columns and rows. I have only 4 columns though. That leaves lot of space on right and left of page. I want to utilize more space on one page. Can I repeat the columns on same page? In other words, It will look like this

    Col1 Col2 Col3 Col4 Col1 Col2 Col3 Col4

    This way, I can fit double the records (rows) on one page.
    Thanks,

  2. #2
    Join Date
    May 2010
    Posts
    601
    Sure.

    Basic steps:

    1) Choose Page Setup, Page Setup to display the Page Setup dialog box.
    2) In the Print Options tab, make note of the left and right margin widths, as given by the values in the Left and Right text boxes.
    3) Display the Columns tab.
    4) In the Grid Settings group, use the Number of Columns text box to type how many columns you want to use in your report.
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  3. #3
    Join Date
    Jul 2009
    Posts
    5

    Report

    Thanks. That worked somehow.

    Do you know how would I use summation function in report. For example, If I want to show total number of female in one columns and total number of males in another column from a table column that stores all males as M and Females as F with each having unique Id associated to it.

    Thanks,

  4. #4
    Join Date
    May 2010
    Posts
    601
    Several ways to handle this. I ofter use a sub report to print summary totals. Tis allows you to use a totaling query.

    It may be possible to use set the control source of a text box in the group or report footer. For a text box named txtMales set the control source to:
    =Sum(IIF([Sex]="M",1,0)
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  5. #5
    Join Date
    Jul 2009
    Posts
    5
    Actually, in my table, I have to work with three fields,

    1. EntryDate
    2. Sex (Male or Female)
    3. Id

    When the User provides date range like DateFrom and DateTo.
    I need to run some query that shows in report like this.

    Total Rows Male Female
    25 21 4

    Select Count(Id) as 'Total Rows', Count(Sex) as 'Male' where sex = 'M', Count(Sex) as 'Female' where Sex = 'F'

    Now this above query is dirty. But you got the idea. I need help to clean it. Thankssss.

Tags for this Thread

Posting Permissions

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