Dear Tim,
I have on my database a field called 'restriction' in which I
enter a closure period. My hope is that when we get this lot up
as an OPAc some clever guy will tell it not to display any record
where the value of Restriction is greater than zero.
The value in the field represents not the time of restriction
remaining but the terms of deposit, e.g. '30' for closure period
after last date in file. A simple exercise, macro, query or what
you will, does a jolly sum and tells me on 1 Jan. each year what
is due to be unrestricted. All I need do then is adjust Restriction
field to zero.
Dr Elisabeth Leedham-Green
Deputy Keeper, Cambridge University Archives
University Library, West Road, Cambridge CB3 9DR
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
|