> Does this help? > Thanks, Brian, that is a rather creative workaround. However, I need separate figures for each month, even though the data is all in one table. Your solution would require an additional twelve columns. While this is possible, it would be ugly and make maintenance problematic.
In SQL, I am looking for (for February for example, but there will be a cell for each month) (note dd/mm/yyyy format, not mm/dd/yyyy format): SELECT colC from TABLE WHERE colA=>01/02/2009 AND colA=<28/02/2009 AND colB=="viscoplastic" I would then sum the values of colC that I got back. I know that Base would make this easier, but we are using data from a d2a converter that outputs in excel format. Because of further processing, it would be cumbersome to convert that to Base. Note: I accidentally mentioned that the data is in mm/dd/yyyy format when it is in dd/mm/yyyy format. Sorry for the error, that was after going crazy with OOo's insistence upon using mm/dd/yyyy when we want something else. -- Dotan Cohen http://what-is-what.com http://gibberish.co.il --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
