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

    Unanswered: Multiple rate table question

    I am trying to rebuild a country club billing program in MS Access to send monthly statements to club members. There are several types of members that are billed at a different membership rate based on their member classification. Is there a way I can calculate the member’s monthly balance based on a matching field in a multiple rate table. Thanks for any help in advance!

  2. #2
    Join Date
    Jan 2005
    Posts
    31
    Quote Originally Posted by Kent Latch
    I am trying to rebuild a country club billing program in MS Access to send monthly statements to club members. There are several types of members that are billed at a different membership rate based on their member classification. Is there a way I can calculate the member’s monthly balance based on a matching field in a multiple rate table. Thanks for any help in advance!
    Yes.

    Aircode:

    Code:
    SELECT M1.FName
          ,M1.LName
          ,MC1.MembershipClassification
          ,MR1.Rate
      FROM (MembershipClassifications AS MC1
            INNER JOIN
            MembershipRates AS MR1
        ON  MC1.MembershipClassificationsID = MR1.MemebershipRatesID)
            INNER JOIN
            Members AS M1
        ON  M1.MembersID = MC1.MembersID
    That was, of course, completely off the top of my head, it is meant more to get across the general idea that be a guantee of exactly what you need.

Posting Permissions

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