Re: Create Lists which match data

[Elizabeth Thomsen <et at noblenet dot org>]

This is one of those things that you can't do directly in Create Lists, at 
least yet.  The program is only designed to search for what's in a 
particular field, using =, has, greater than, etc.  Each search line just 
looks at a particular field, and, although you can use a lot of different 
lines, each line is really a separate search.  

In other words, you can't do ask Create Lists to compare the contents of 
one field with the contents of another. The only solution that I know of 
for this kind of query is to take the data off the system, move it into a 
program like Access or Excel, and use that program to compare fields and 
give you the record numbers for one with matches.

That said, is there another way to think of this based on the way you do 
expiration dates?  Is the expiration always in a year or two or three?  
Maybe something as simple as looking for records where the create date has 
2004 and the expiration date has 2004, repeated for each year, might 
identify likely problems.

Elizabeth

On Wed, 27 Apr 2005, Pollecutt ,Ms Natalie wrote:

> Dear all,
> 
> I would like to create a list that gives me patron records where data in
> one field matches data in another field. Sometimes when patron records
> are created they are accidentally given that day's date as the expiry
> date, so I'd like to a list that tells me records where create date =
> expiry date.
> 
> Despite trying various different ways and looking in the manual I can't
> see how to do this - I think I can only match against specific criteria,
> rather than data in another field in the same record. Does anyone know a
> way I can do this?
> 
> Thanks in advance,
> 
> Natalie Pollecutt
> 
> --
> Natalie Pollecutt
> Library Systems Officer
> Wellcome Library for the History and Understanding of Medicine
> 210 Euston Road
> London NW1 2BE
> Telephone: +44 (0)20 7611 8845  Fax: +44 (0)20 7611 8369  Email: mailto:n dot pollecutt at wellcome dot ac dot uk  Website: http://library.wellcome.ac.uk/
> The Wellcome Trust is a registered charity, no. 210183. 
> Its sole Trustee is The Wellcome Trust Limited, a company 
> registered in England, no. 2711000, whose registered office 
> is 215 Euston Road, London NW1 2BE.
> 
> 
> 
> --
> This message was distributed through the Innovative Users Group INNOPAC list
> Public replies:  INNOPAC at innopacusers dot org
> Update your subscription options: http://innopacusers.org/mailman/listinfo/innopac
> 


-- 
Elizabeth Thomsen, Member Services Manager
NOBLE: North of Boston Library Exchange
Danvers MA 01923
et at noblenet dot org