Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   Need some clafication on queries (http://www.go4expert.com/forums/clafication-queries-t1252/)

augie0216 22Aug2006 09:41

Need some clafication on queries
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 24Aug2006 06:58

Re: Need some clafication on queries
Ideally the calculations should either take place in Query or in reports.

All times are GMT +5.5. The time now is 00:17.