Need some clafication on queries

augie0216's Avatar
Newbie Member
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?
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Ideally the calculations should either take place in Query or in reports.