Need some clafication on queries

Discussion in 'MS Access' started by augie0216, Aug 22, 2006.

  1. augie0216

    augie0216 New Member

    Aug 1, 2006
    Likes Received:
    Trophy Points:
    I suppose to follow these instructions:

    Make a list of 20 patients

    Create a total of all account balances, so that the total amount of receivables can be known

    For each account, calculate the number of days each balance has been outstanding

    Classify the accounts into four categories three late(30,60, and 90 days overdue and one current ( under 30 days) Total the amount of outstanding receivables for each of these categories

    Sort the database using the number of days the account balance is outstanding as the primary sort key and the outstanding balance as the secondary sort key.

    Save the newly sorted database.

    My question is shouldn't all calculations take place in a query and not in tables?
  2. shabbir

    shabbir Administrator Staff Member

    Jul 12, 2004
    Likes Received:
    Trophy Points:
    Ideally the calculations should either take place in Query or in reports.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice