Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2012
    Posts
    2

    Unanswered: Contract Details in Access

    I have created a database to record all my clients / customers contract details.
    we are invoicing our customers after every quarter from the starting date of contract till the end of contract.
    Like Start Date : 01-01-2012
    End Date : 31-12-2012
    Payment : Quarterly
    1st Quarter = 31-03-2012
    2nd Quarter = 30-06-2012
    3rd Quarter = 30-09-2012
    4th Quarter = 31-12-2012

    i want to create a report every month which shows the due payment of each client for the particular month.
    Hope some one can understand what i am trying to do
    thanks in advance

  2. #2
    Join Date
    Jan 2009
    Location
    Kerala, India
    Posts
    183
    I think you need four different queries to prepare due reports for each quarter.

    Quarterly Criteria can be:

    1. Date()-[Contract Date] >61 and Date()-[Contract Date] <=91 then payment due for first Quarter.
    2. Date()-[Contract Date] >152 and Date()-[Contract Date]<= 182 then payment due for second Quarter.
    3. Date()-[Contract Date] > 243 and Date()-[Contract Date]<=273 then payment due for third Quarter.
    4. Date()-[Contract Date] > 335 and Date()-[Contract Date] <=365 then payment due for third Quarter.
    www.MsAccessTips.com (Learn MS-Access Tips & Tricks)
    Learn Advanced MS-Access Programming with sample VBA Code.

    All responses are based on Access 2003/2007

Posting Permissions

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