Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by MagpiesNewsstand
-
How to SUM a column in single table query
As a very interested novice at this, please excuse my need to ask for some fairly elementary hand holding. In regard to your first suggestion: How do I instruct a query to return the answer as something other than answer.db? As for the second: Is the calculated field part of a query?, or a...- MagpiesNewsstand
- Post #5
- Forum: Corel: Paradox
-
How to SUM a column in single table query
Tony, Thanks for the speedy response. The query I have set up on Tranhist.db results in an answer table (26 pages)with Date(>=1/1/06), Trans#, Item, Qty, Price, and Total Price (on that line only). What I am hoping for is a new line at the bottom(?), top(?) indicating the total Qty, and the sum...- MagpiesNewsstand
- Post #3
- Forum: Corel: Paradox
-
How to SUM a column in single table query
In running a query to show all sales from a single vendor, I have been unable to then SUM all of the quantites sold, as well as SUM the total prices.- MagpiesNewsstand
- Thread
- Replies: 5
- Forum: Corel: Paradox
