none
making report with two columns. RRS feed

  • Question

  • Hi dears.

    I want to make a monthly sales report for each year from two tables. I need to print this report with two columns, Left column for odd number months and right column for even number months in the detail section of the report.

    Any solution will be appreciated.

    Friday, June 17, 2016 10:03 AM

Answers

  • A possible solution is to use two subreports - with one on the left that selects only odd numbered months, and one on the right that selects only even numbered months.

    The criteria for the subreport queries would be something like this -

    ODD months:

    WHERE month(YourDateField()) Mod 2 <> 0
    

    EVEN Months:

    WHERE month(YourDateField()) Mod 2 = 0


    Miriam Bizup Access MVP

    • Marked as answer by mohammadpixel Friday, June 17, 2016 2:26 PM
    Friday, June 17, 2016 10:12 AM

All replies

  • A possible solution is to use two subreports - with one on the left that selects only odd numbered months, and one on the right that selects only even numbered months.

    The criteria for the subreport queries would be something like this -

    ODD months:

    WHERE month(YourDateField()) Mod 2 <> 0
    

    EVEN Months:

    WHERE month(YourDateField()) Mod 2 = 0


    Miriam Bizup Access MVP

    • Marked as answer by mohammadpixel Friday, June 17, 2016 2:26 PM
    Friday, June 17, 2016 10:12 AM
  • Tanks Miriam. I used your suggest, that was ok.

    Friday, June 17, 2016 11:35 AM
  • Please mark this post as answered by Miriam so others can benefit from her solution.

    Best regards, George

    Friday, June 17, 2016 12:44 PM