Paradox queries are very powerful and are what makes your apps useful. "calc min" will return the minimum value of all the numbers. Look up "calc" in help, as there are other things you can do in a query with this word, like "calc ave" (do not include quotes in actual query) to calculate the average of all the numbers in a field. Likewise, do not have any other fields checked, as you are asking the query to do contradictory things. Checking the field confuses the query, as you are then asking to calculate each individual entry and will get nonsense returned. This will calculate the sum of all the numbers in that field. You enter calc sum, but DO NOT check the field. What do you enter in the little gray area to the right of the green check mark to get p9 to sum on that field?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |