Hello David
We have a report that we run in SQL. It is
FF00,FF00,0000Courier Newselect
FF00,FF00,F000barcodeFF00,0000,0000,FF00,FF00,F000titleFF00,0000,0000,FF00,FF00,F000authorFF00,0000,0000,FF00,FF00,F000classificationFF00,0000,0000,FF00,FF00,F000itemtypeFF00,0000,0000,
FF00,FF00,F000deweyFF00,0000,0000,FF00,FF00,0000
FF00,FF00,F000dateaccessionedFF00,0000,0000,FF00,FF00,F000priceFF00,0000,0000,FF00,FF00,F000replacementpriceFF00,FF00,0000
from
FF00,FF00,F000itemsFF00,0000,0000,FF00,FF00,F000biblioFF00,0000,0000,FF00,FF00,F000biblioitemsFF00,FF00,0000
where FF00,FF00,F000dateaccessionedFF00,FF00,0000 FF00,0000,0000>=0000,FF00,F000'2003-11-01'FF00,FF00,0000 and
FF00,FF00,F000dateaccessionedFF00,FF00,0000 FF00,0000,0000<<=0000,FF00,F000'2003-11-30'FF00,FF00,0000
and
FF00,FF00,F000itemsFF00,0000,0000.FF00,FF00,F000biblioitemnumberFF00,0000,0000=FF00,FF00,F000biblioitemsFF00,0000,0000.FF00,FF00,F000biblioitem
numberFF00,FF00,0000
and FF00,FF00,F000itemsFF00,0000,0000.FF00,FF00,F000biblionumberFF00,0000,0000=FF00,FF00,F000biblioFF00,0000,0000.FF00,FF00,F000biblionumberArial
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
7F00,0000,0000> 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?
Rosalie Blake
Head of Libraries, Horowhenua Library Trust