Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Complicated cost tables

    Hi All!!!

    i'm trying to create a database that will store resource information like books, subscriptions, online subscriptions, CD-ROMs, etc. I need to track their costs which is where I'm having trouble. Some of these, especially the subscriptions would have an annual fee and a monthly/weekly fee. How can I track how much is due each month while knowing whether this is an annual cost or a monthly/weekly fee? Do i need 2 or 3 separate tables to record this information? Do I need to type every month a different due date?

    Any help will be very much appreciated! Thanks!

  2. #2
    Join Date
    Feb 2004
    For each subscription keep following optional information. - it will be one subscription to many charges.

    . Subscription Id
    . Amount ( Flat rate or percentage ?)
    . Duration (Annual, Monthly, Weekly, OneTime ?)

    Attached doc can help.
    Based on subscription start date, other charges/fee can be calculated.

    Hope this help.
    Attached Files Attached Files

Posting Permissions

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