Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2011

    Unanswered: How to print From and to Months

    hi all
    i have a report based on a query, the query nicely extracts all the records from database

    who have not paid the dues. we send the report as a reminder to our students that they have

    not paid their due for the following months for example
    You have not paid your dues for
    April 2014
    May 2014
    June 2014
    July 2014 and so on

    Now the question is that instead of printing all the unpaid months one after the other, i

    want only to print the starting month, in this case From April, 2014 to and the Current

    month i.e. July, 2014. How can i do that?

  2. #2
    Join Date
    Apr 2014
    Provided Answers: 33
    You have dates on a form, txtStartDate, txtEndDate for users to enter.
    The form can have quick pick date ranges, or manual..use these text boxs as criteria in the query.

    Click image for larger version. 

Name:	reports.png 
Views:	4 
Size:	13.7 KB 
ID:	15845

Posting Permissions

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