>Hi all, the query below produces a count and summation of monies by month, it works perfectly but *pretty it ain't*, anyone know of a *nicer* way of doing this ?
If you have to have 24 columns, then your statement has to have those 24 rows. The nicer way would require reforming the calendar, and perhaps changing the orbit of Earth to produce a year of 256 or 512 days... so it's easier to leave as is.