1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Need some clafication on queries

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

  1. augie0216

    augie0216 New Member

    Joined:
    Aug 1, 2006
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    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

    Joined:
    Jul 12, 2004
    Messages:
    15,285
    Likes Received:
    364
    Trophy Points:
    83
    Ideally the calculations should either take place in Query or in reports.
     

Share This Page