Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2015

    How to manage schedule payments in access 2007

    Good day!
    I have developed a real estate database. I am stucked at the point where I need to store schedule amounts received. I managed to create a form for the schedules of clients with for each loop but in receipt form I only can update matching dates. In case, where a client e.g does not pay amount on time (random monthly basis ). Therefore the months of receiving amounts are making hurdles to match schedule dates with receiving date. How and what stretegy I should use to accomplish the task?
    Last edited by aaronejaz; 08-14-15 at 14:55. Reason: Some typing mistakes corrections

  2. #2
    Join Date
    May 2016
    Hi aaronejaz

    You need to add

    • a payment Day on your entity corresponding to Rental entity
    • a Check payment entity in relation with Rental entity

    And write an Sql script to check which Rental has no record in Check payment entity for the current date if its day is superior or equal to the payment date
    Last edited by informer; 08-16-16 at 01:00.

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