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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: sparklewoman
- Order by date
-
date into quarters
The sum is performed in a cursor before the printing on the report here is an example: PREPARE p_sum2 FROM "SELECT SUM(receivable) FROM temp_open1 \ WHERE branch = ? AND repnum = ? \ AND MONTH(selectdate) = MONTH(TODAY) - 1 \ AND YEAR(selectdate) = ...- sparklewoman
- Post #3
- Forum: Informix solutions
-
date into quarters
I have to create a sales report using current quarter totals and previous quarter totals. What is a simple of way breaking down the months in quarters and query on a sum for example invested amount?- sparklewoman
- Thread
- Replies: 2
- Forum: Informix solutions
