Hello David We have a report that we run in SQL. It is <bold><color><param>FF00,FF00,0000</param><FontFamily><param>Courier New</param><bigger>select</bold> <color><param>FF00,FF00,F000</param>barcode<bold><color><param>FF00,0000,0000</param>,</bold><color><param>FF00,FF00,F000</param>title<bold><color><param>FF00,0000,0000</param>,</bold><color><param>FF00,FF00,F000</param>author<bold><color><param>FF00,0000,0000</param>,</bold><color><param>FF00,FF00,F000</param>classification<bold><color><param>FF00,0000,0000</param>,</bold><color><param>FF00,FF00,F000</param>itemtype<bold><color><param>FF00,0000,0000</param>, </bold><color><param>FF00,FF00,F000</param>dewey<bold><color><param>FF00,0000,0000</param>,</bold><color><param>FF00,FF00,0000</param> <color><param>FF00,FF00,F000</param>dateaccessioned<bold><color><param>FF00,0000,0000</param>,</bold><color><param>FF00,FF00,F000</param>price<bold><color><param>FF00,0000,0000</param>,</bold><color><param>FF00,FF00,F000</param>replacementprice<color><param>FF00,FF00,0000</param> <bold>from</bold> <color><param>FF00,FF00,F000</param>items<bold><color><param>FF00,0000,0000</param>,</bold><color><param>FF00,FF00,F000</param>biblio<bold><color><param>FF00,0000,0000</param>,</bold><color><param>FF00,FF00,F000</param>biblioitems<color><param>FF00,FF00,0000</param> <bold>where</bold> <color><param>FF00,FF00,F000</param>dateaccessioned<color><param>FF00,FF00,0000</param> <bold><color><param>FF00,0000,0000</param>>=</bold><color><param>0000,FF00,F000</param>'2003-11-01'<color><param>FF00,FF00,0000</param> <bold>and</bold> <color><param>FF00,FF00,F000</param>dateaccessioned<color><param>FF00,FF00,0000</param> <bold><color><param>FF00,0000,0000</param><<=</bold><color><param>0000,FF00,F000</param>'2003-11-30'<color><param>FF00,FF00,0000</param> <bold>and</bold> <color><param>FF00,FF00,F000</param>items<bold><color><param>FF00,0000,0000</param>.</bold><color><param>FF00,FF00,F000</param>biblioitemnumber<bold><color><param>FF00,0000,0000</param>=</bold><color><param>FF00,FF00,F000</param>biblioitems<bold><color><param>FF00,0000,0000</param>.</bold><color><param>FF00,FF00,F000</param>biblioitem number<color><param>FF00,FF00,0000</param> <bold>and</bold> <color><param>FF00,FF00,F000</param>items<bold><color><param>FF00,0000,0000</param>.</bold><color><param>FF00,FF00,F000</param>biblionumber<bold><color><param>FF00,0000,0000</param>=</bold><color><param>FF00,FF00,F000</param>biblio<bold><color><param>FF00,0000,0000</param>.</bold><color><param>FF00,FF00,F000</param>biblionumber</color><FontFamily><param>Arial</param><smaller> This is the report for the month of November 2003. You can change the dates as you wish, or add different fields to the display. Rosalie Blaske Horowhenua Library Trust <color><param>7F00,0000,0000</param>> On Tue, 2 Dec 2003, David M. Bucknell wrote:
Dear Pat,
Thank you for answering re. acquisition repots. Apparently, our
library would like to have reports the last 24 hours, the last week,
the month and perhaps the year. Possible?
<nofill> Rosalie Blake Head of Libraries, Horowhenua Library Trust