Create Lists in Millennium

 

Create Lists in Millennium Conventions Fields in Records Exercises Exercise One: adapting an existing search Exercise Two: creating your own search Additional searches Exercise Three: Search and extract data Exercise Four: Extraction Sort first, List later First output report: List records Second output report: Excel Additional Resource Drafts

 

[version 20081218a]

 

 Here's one that EVERY FULL TIME STAFF MEMBER SHOULD KNOW HOW TO DO.  Period.

 

Millennium makes it pretty easy, and I make it even easier by saving a lot of canned searches that you can adapt.

So, we're going to try both kinds, and then get the results out.

 

First comes the really hard part -- you have to read one of my manuals.    Yeah, that's a tough assignment.

 

This is linked in the Staffmarks menu, or just click here to get the correct manual.   (Use a right click and open in another window or tab, if necessary.)

 

Conventions

 

Remember some important things:

 

 

There are some other conventions used in the bibliographic files which can help you.  We'll go over some of them as they come up.

 

Bear in mind that we've had to adjust how we use the different kinds of records over the years, and sometimes something you want to find is in one field in an older record, and another field in a new record.  So, you may need to search both places if you go back very far. 

 

Fields in Records

 

To use Create Lists properly, you need a little understanding of how the records work in Millennium.  Some of the same basic principles apply whether you are using a bibliographic record, an item record, a patron record, etc.

 

For example, let's take a bibliographic record.

 

> A bibliographic record may have other records attached to it: item records (usually with barcodes for specific items), Media records (pictures, sound files, etc.).  If you want to select something, you can use an item record search but narrow it down with qualifications from the bib records that the items are attached to, or vice versa.

 

> Fields in a record may be fixed fields (unable to have kittens... no, wait-- I mean, only able to have certain things in those fields, and limited to a certain number of characters).

These are the fields up in the grid at the top of the record.  Double-clicking on any of them usually gets you a drop-down menu of the possible choices allowed for that field.

 

> Or, the fields may be variable and have many things in them (even if not allowed, you'll just get a red subfield marker but still be allowed to include it, such as the red markers for the |e and |f subfields in call numbers -- officially, those are not normally allowed, but we use them so we can have multiple lines in labels.).

These are the fields with letters on the far left, then field numbers, indicators, and the fields that go down the rest of the record.

 

> You can mix fixed and variable fields to select records (as long as they are attached to each other).

 

> Variable fields have letter indexes shown with them.  For example, let's look at a field used for order information:

 

n 541     amazon|cFY2009 breg|dpcard080926a |e2009 ed.; 9781234567890|3pbk.|h$19.95|n(cost 14.50)|fjs*wc

 

The n at the start of the line is for the Notes index, and all the notes fields can be searched using that index.  That's any field with an n in front of it.

[Note: not all of these fields are visible in the OPAC, however.  You may need to change to the MARC record to see them, such as the 541.]

 

The 541 is the standard field number for a MARC record.  The n is just for III users, so it won't show up that way in other systems.  Also, you don't see the n in OCLC or in the OPAC.

 

The first word in a variable field is considered to be in the a subfield, so it's not marked with a subfield indicator -- just assume that's what it is.

 

All the other subfields after that have the pipe | to indicate other subfields: |c , |d , and so on.  Each of those has a specialized use, so let's use this 541 field for an example, especially since you'll need some of these fields later.  Bear in mind that spaces before and after the subfield indicators are optional so all this might be crammed together with fewer spaces.

 

Please remember to NOT change these unless you are authorized.  If you accidently change one, do NOT save the record.  Exit, refuse to save, and then you can go back in.  The original should be back to normal.

 

n 541     amazon |c FY2009 breg |d pcard080926a |e 2009 ed.; 9781234567890 |3 pbk. |h $19.95 |n (cost 14.50) |f js*wc

 

The first field (assumed to be |a, remember?) is reserved for the vendor: amazon

 

The |c is for the fiscal year code FY2009 and the fund account code.  I use FY2009 instead of FY space 2009 because 2009 could show up lots of places, but the only place I use FY2009 all jammed together is for the fiscal year of the order.

 

|d is for the method used to order (pcard plus date and a code, or the Req number, or "donor" and perhaps a name if donated)

 

|e is for details on the exact item if necessary, such as "2009 ed.; 9781234567890" -- the edition and the ISBN.  I don't always need this, but it helps a lot on serial records or multi-volume records.  (Yes, I know it makes the field longer and maybe bit harder to read, but I really NEED this stuff!)

 

|3 is for the binding and -- if I get it prebound -- it says that.  I don't bother with this if not paperback/spiral or other special binding.

 

|h is for the list price, and |n is for the actual cost (which is sometimes higher).

 

|f is for any librarian's initials that asked for it, then * approver's initials or name, followed by any other notes (condition of book, when processed, etc.)

 

All most of you need to remember from the 541 field is the FY code so that, if you want fiscal year 2008-2009, you know to use FY2009 (since the year ends in 2009).  That will let you find what we bought in a specific fiscal year.  If you need to specify money amounts, check with me about extracting those (because due to differences between list and actual cost, we might spend a lot more on some titles than list price).

 

Title fields have a t index, author fields have an a index, subject fields have a d index, and the rest you can see in the specific records.

 

Now, for a patron record, you have the same thing: fixed fields and variable fields with letters in front.

 

Patron names have an n index letter in front.

 

Patron barcodes -- because we usually have two -- have  a b in front of a "20000number" and a "@000number" because one @ in the b field is worth "20" in another b field. 

A @ in the b is worth "20" in another b.

We see and read the @ number (because that's what Banner uses) but the barcode actually reads the "20" number.  So both of them are in there because they have to be. 

 

And if there's a public patron card number, that goes in yet another such b field.

 

Email addresses have a z index, and so on. 

 

All of these correspond to the drop-down menu in Millennium.

 

 

(This is for Cataloging so the indexes are for bib and item records.)

See the letters of the indexes to the left of the choices?  Yeah, that's what that means.  Same thing in each module, with the variations for the records used in that module (some indexes may not show up in some modules).

 

Exercises

 

* Now, for the exercises, I recommend you use MilCat (Millennium Cataloging) as that is the most complete form of the Create Lists for most functions (with a few exceptions).  You log in to Millennium with your initials plus "cat" and your password to start MilCat.

 

* In the left sidebar, click on Create Lists to get that function up.

 

* Click on the Name at the top of that column and see the lists alphabetize.  This also puts all the Empty lists together, so you can find the right size easily.

This will also put all the lists with names that begin with your initials together.

 

Exercise One: adapting an existing search

 

* Follow the instructions and, for this example, choose an empty file with 500 records in it.

 

* Click that list, then on Search and open up the Boolean Search window for the file.  Name it with your initials followed by the words training file.

 

* Go to the bottom of the window and click on Retrieve Saved Query.

 

* Scroll down and find the search called dv * Faculty request for FY???? and select that one.

(sorry - I've asked to have these alphabetizable but it's not done yet)

 

Now, remember that you are only borrowing this search, so you do NOT want to save it unless you use another name for the search.

It's okay to save a search under another name with your own changes -- just put your initials first, so we all know who's to blame -- uh, discuss it with.

 

Providing nobody changed it and saved it under the same name, you see a search filled in.

 

* Now, put your cursor on the top row (Type, Field, Condition, etc.) and drag the right divider of the Field column over to the right, so you can see all of the contents.  When the cursor becomes a two-headed horizontal arrow, you're in the right place, so hold down the left mouse button and pull the line over to the right.

 

Okay, now we can see what's really happening:

 

 

Term 1: The first line is searching in the bibliographic record, in the MARC Tag 599 field to see if it has Kannan in it.

599 is where I put the REQUESTOR information.

This is a 5xx note field, but we want to search a specific note, so I entered an exclamation point (!) in the Field box which is the signal to use a specific field tag like 599 instead of just a general category tag like n for Note.  You'll see how this works later.

 

Term 2: Now, in addition to that (AND operator in the far left column), we have a fiscal year.  All the fiscal years going back before 2000 should be in the form of "FY" followed by no space and the year.  Now, "FY2000" is not a normal word, where "2000" might show up several other places, so searching by "FY" followed directly by the year in the 541 field should take care of limiting the search to a year.

 

If you need several years, however, this is NOT a fixed field (limited to just certain characters) so you would have to add another search:

FY2000 OR FY2001 OR FY2002 and so forth.  Each would be a line, and you would group them in the same way the search for Kannan is.  Since this is not a fixed field, we cannot use a "from this to that" kind of search -- sorry about this to that.

 

But, let's assume that YOU want to search for a different faculty member and a different year.  Can you adapt the existing search?

 

* Change the name to Beard in Term 1, and change the year to FY2005.  Do NOT save the search, just use it.

 

* Click on Search and confirm it, and get the results.

 

Not so hard, right?  So, let's complicate it a bit. 

 

* Go back to the same file, and get the search window again.  You'll be warned about over-writing the contents of the file.  Go ahead anyway and click on Yes.

 

This time, let's assume you want something a little more complex.

 

* Use the Retrieve Saved Query to get the same search again: dv * Faculty request for FY????.

 

* Now, right under the line for Kannan, put the cursor on the next line and click on Insert Line to get a blank line.

 

* Type a b in the Type column of the new inserted line.  You want to look in the bibliographic record.

 

* Type an ! (exclamation point) in the Field and get a popup window asking for a specific field number and, if you like, a subfield.   In that, type 599.

 

* Type h for Has which means it searches anywhere in that subfield.  Of course, if you weren't sure about the subfield, you could just put 599 and the h would let you search anywhere in the entire field.  BTW: this works if you have multiple fields of 599, or whatever -- it will search all the 599 fields.

 

* Type Buchanan in the Value A field.

 

Now you have a search for both Drs. Kannan and Buchanan.  (Fowl and Fish, as it were...   )

 

We're not done yet, however.

 

* Change the Buchanan line so the Operator field on the far left is OR.

 

* Highlight Term 1 and hold down the Ctrl Key while you highlight Term 2 with it.

 

* Click on the Group button and group the names, but NOT the FY line.  We want the FY line to apply to any of the grouped lines that find a hit.  Look at the formula that is shown in the white space below where you are working, and see how the whole thing looks in Boolean.

 

* Keep the last term as FY2006.

 

* Search the file and see what you get.  You'll probably turn up 21 bibliographic records.  These are the titles that were requested in FY2006 by Kannan OR Buchanan.

 

You can add a lot of names this way.   You can use the same principle to add fiscal years, too.

 

Okay, now let's consider a problem.  (You just knew we'd have some of those...)

 

What if we only want stuff we actually have available for a specific program?  Nothing still on order, being considered, etc.?  It would look rather odd to give a list to an accreditation team of stuff we don't actually have, wouldn't it?

 

When you ask for something in the OPAC, it automatically weeds out anything not available for use someplace, but that is NOT the case in Millennium, because you might need to work with those records sometimes.  So, you have to limit the searching yourself.

 

Easy, right?  Just set one of the Terms so fixed field 31 Status is equal to "-", right? 

Well.... not quite.

 

The "-" status in 31 is only for circulating materials.  What about Reference (l for Library use)?  What about online ebooks (i for Internet access)?

 

* Select your file again and this time use the dv * Owned for this PROGRAM search.

 

Notice that we have a Program name at the top, and then a grouped set of terms to cover all the forms of a record that is available in some manner in the catalog: circulating (-), Reference (l) and online (i).  That group is "OR"'d together so any one of those 31 Status settings would cause it to be accepted, if it had the right Program as well.

 

 

* Use the ELECTRICAL program (since the word "ELECTRICAL" occurs in PROGRAMELECTRICAL it works to use it alone IF you use the "has" condition but not the "=" condition) there and run the search for bibliographic records (or if you like, change the Program name to something else).

 

Exercise Two: creating your own search

 

Let's use that same file again and try something a little more creative.  Let's combine record types.

 

* Click on Search Records again for that same file, and this time go right to the first term.

 

* In the first line, instead of a b in the first field, put an i in there for item records.

 

* For the Field, double click and get the list of possibilities.  Select IType.

 

* When dealing with fixed fields such as IType, you don't normally use Has.  You are more specific, using = or some mathematical combination.  Select the equal (=) sign for Condition.

 

* Double-click on Value A and get the list.  Select 50 for CD 21 day.  These are the CD-ROMs that come with books, so we check them out for the same length of time the book is out.

 

* Click on the Append Line button twice to get two new lines.

 

* For Term 2, select Type as b.  That's right, you can mix record types when you select criteria, even though the final result must be only one type of record in the file.

 

* Select exclamation point (!) for the Field, and enter 690.  This is where we have the Programs, among other things.

 

* The Condition is Has because we're going to pluck a term right out of the inside of the field (PROGRAMSCIENCE).

 

* Value A is SCIENCE.

 

* Term 3 is b, ! (exclamation point),541, h, and then FY2006.

 

 

What are we searching for?  We're looking for the FY2006 books in the Sciences that came with CD-ROMs. 

Since we picked the type as 50, with a checkout length of 21 days, we must be looking for materials that came with books, since separate A-V items would be only 7 days.  CDs that come with books have the same check-out period of books.

 

 

This is just a example (which comes up empty, by the way).  But the basis is sound.

 

Additional searches

 

Here are some additional searches that can be adapted easily, and show the process:

 

dv * PROGRAM: search for FY????

 

 

 

You can change Term 1 to the fiscal year you want to search in the 541 field.

You can change the program you want to search in the 690 field.  (Remember: "music" would get you both MUSIC in general, and also anything on Music Education, so you might want to be more specific with terms like this, if necessary.)

 

Terms 3 through 6 are the status fields, and cover - for available, r for Received (but not yet processed), i for Internet access (ebooks, for example), and l for Library use only (reference).  This would NOT include materials still on order, for example.

 

dv * Ordered/received FY???? for PROGRAM:

 

 

Term 1 gets the fiscal year, and Term 2 gets the Program.  Since we didn't specify status, we will get stuff on order, stuff missing, stuff we have, etc. -- everything.  So, you may or may not want to be more specific by adding more Terms.

 

Exercise Three: Search and extract data

 

Let's try a search that you might really have to do for a faculty member, and extract the data in several ways.

This time, use what you have learned already for some of the criteria you enter.

 

* Reuse that same file and Search Records.

 

* The first term is for the fiscal year FY2006.  You should have no trouble doing that one yourself.  You already know it's in the bibliographic record, in the 541 field.

 

* Your next term is to search inside the bibliographic records, in the 690 field, for records that have literature.  You should know how to do most of that already, until you come to the Value A field.

 

Now, literature is listed with a 690 of PROGRAMLIT [something], for PROGRAMLITERATURE (about lit in general), PROGRAMLITAMERICAN, PROGRAMLITBRITISH, or PROGRAMLITWORLD -- which you could look up in the Program list online, if you had to check.

 

That same word might turn up other places in the same record, but it has to be in that exact form in that exact field to be what you want. 

 

* Enter it in the Value A field exactly like that, colon and all.   PROGRAMLITWORLD

 

* Click on the Append Line button.

 

* Now you need it for a specific type of literature, say, French.  (We're looking for English translations of French lit, rather than lit in French, but unless a text is actually in another language, we assume all our works are in English.) 

 

That would show up where?  In the regular subjects.  You can cover all the 6xx fields by using the subject index code instead of a specific field number.  Search bibliographic records, in the d field (for subjects), for records that have french in the subject.

You don't want to use French literature because the subject might be, say, French fiction or French drama or something other than literature.  Computers are very literal.

 

* Click on the Append Line button.

 

* Wait a minute, wait just a minute -- what if the reference was to France instead of French?  Better get a line in for records that have France in the subject. 

 

* Remember to change the Operator for the second d line to OR.  Otherwise, a record would have to have both French and France in subjects.

 

* Click on the Append Line button.

 

* Now you can Group the two d subject lines together so the Boolean works properly.

 

If you like, move the Field column line over so you can see all the selection, as you did at the start of this.   You can do the same to the Value A column. Then you can review and maybe even print your screen.

 

* This time, use the Save As button and save your search under a new name, starting with your initials followed by training file.

 

* Search the file.  You should get some records (depending on changes in inventory since I wrote this!).  If not, call up your search again, go back over it and see what you need to correct.  Then run it again.

 

Exercise Four: Extraction

 

Sort first, List later

 

First, let's put the records in some kind of order.

What do you think most faculty would want separated?  Probably media.  They often get asked about how many books, how many DVDs, etc. we have specifically.

 

And then we could list the materials under call number, to group them more closely by subject within each media group.

 

* Click on Sort Records.  You start with one blank line.

 

* Click on Append Line, since you know you'll need a couple of lines.

 

* In the first line, the Type is the same as in searching: b for bibliographic records, i for item records, etc.  Enter a b in this case.

 

* Doubleclick in the Field blank, and look for the BType.  Select that.  You don't need a value, since you're sorting, not selecting.

 

* Second line: also a bibliographic record, and doubleclick.  What do you use to sort by Call #?  Select it.

 

 

* Click on the Sort/Save button at the bottom of the popup window.  Be sure the Status reads Complete again before continuing.

 

WARNING: sometimes the number of records will increase when you sort, usually when you sort (usually during a Title t search).  Check with Dennis when this happens to fix it in the long term.  Meanwhile, you can open up the list and use the Dedupe button to remove the duplicate listing for a record.

 

First output report: List records

 

The first way we'll get the results out is using the built-in List Records function in Millennium.

 

* With the file you just created highlighted among the other files, click on the List Records button. 

 

* Click on the Append Line button, and get yourself 4 lines.

 

* The first thing is to let the reader know that you sorted by media type.  It's a bibliographic record, and use the BType.

 

* Next you sorted by call number, so use that for the second line.  You can figure it out.

 

* The title is probably most significant, so let's put that next.  Rather than using the field number, just use the t code for Title.

 

* Now, some titles have different editions, or are continuing serial publications, so we need to get that sort of thing in.  Also, some titles are very similar between publishers, and if this is going to be seen by an accreditation team, it might make a difference to them if it was published by X or by Y.

So, I like to put in the 260 field, but to do that, I just use the p for imPrint code in the fourth line.  That saves having to specify the 260 field.

 

VERY IMPORTANT FOR CURRENT FISCAL YEARS:

If this was for THIS fiscal year, we might have some materials that haven't arrived as yet (and maybe won't, depending on a lot of factors).  Let's not confuse the accreditation team with what we hope we'll get -- let's be clear as to what we actually have, so they don't get confused by might-have-beens.

For that reason, I would add another output field line, and make this for BStatus.  That will say Available, Received, or Ordered.

 

* Enter the page heading.  Remember, we should be very clear about what this is, and how up-to-date it is.

After all, you might be asked for another list with later information as time goes on.

 

I like to say something like "Boreham Library subject-related Materials as of" and add the date.  The subject, of course, is whatever you're using.

In this case, how about your name, followed by "French Literature" and then the date.

 

* The records should start and end with the default records.  However, for Number of blank lines between records, I like to have 1 blank line in there for easy reading.

 

* Sometimes people like to count entries.  Let's make it easier by checking the first box for Number the records in the list.

 

* Let's be clear about what means what, so check the second box for Display meanings of fixed-length codes so that the BType field (and if used, the BStatus) will be shown along with what is in the field.  That way, "-" will instead say "Available", and so on.

 

* Leave the Display each variable length field on a new line checked.  This makes for easier reading.

 

I usually don't check the Display labels for variable-length fields as they tend to be pretty obvious (like "Title"), and it clutters the page.

 

* UNcheck the last box for print in uppercase as all-uppercase is harder to read. 

 

 

* Click okay, then go to the system printer (that's the default printer) and see what you get.

 

I've asked to have the output formats be saved, but that enhancement (while popular) isn't happening yet.  Still, it's not too hard, is it?

 

Second output report: Excel

 

Now let's try this data, but this time, the reader prefers it in an Excel spreadsheet format.  That's especially helpful for large lists, although printing can be trickier.

 

* For the same file, this time click on Export records.

 

* The fields you select can be the same as above.

 

* For Field delimiter, click on it and change the comma to an @ (at) symbol.  Commas are far too common to use for our purposes.

You can also use a tab, if you like.

 

 

* For Text qualifier, select none.

 

 

* For Repeated field delimiter, use the @ symbol again (or tab, if you're using that).

 

* The file name can be short, since the reader won't even see it.  Put your initials followed by "frenchlit".

 

 

* Click on OK.

 

VERY IMPORTANT:

If you have to print this again, the Text qualifer will have to be reset to none again.  It doesn't stay the same from time to time.

Also, if you reselect or change this file, you'll probably have to do the output format again.    Yeah, sorry about that, but as far as Millennium is concerned, it's a whole new file.

 

* Load Excel.

 

* Open a file (manila folder icon on toolbar) and move up to Desktop, My Computer, C:\ drive, and then into Millennium folder.

 

* At the bottom of the window, change the Files of type to All files (*.*) and look for your file.  Doubleclick on it.

 

* Excel tells you this file is in a different format than specified by the file extention (there wasn't a file extension!).  Click Yes to go ahead anyway.

 

* This opens the Text Import Wizard, step 1 of 3.  This is file type delimited (change to that if necessary) and 437 : OEM United States or Windows (ANSI) is okay.

 

* Click on Next.

 

* Unclick Tab and click Other and put a @ in the box.

 

* Change text qualifier to none.

 

* Click Next.

 

* You usually get the best behavior (for our purposes) if all the fields are considered to be Text.  The first field is highlighted, so slide the bar over so you can see the last field.  Hold down the shift key and click the last field.  All the fields should be highlighted now.

 

* Click Text. All the fields should now say Text above them.

 

* Click Finish.

 

Now you have your exported data in a spreadsheet.

 

(Note that your actual results may vary from those in the example, depending on the records in the catalog since I created these screenshots.)

 

* Now, at the top where the columns have letters, start by clicking and sliding the right side of the B (Call #) column over until you can see the entire call number for all the lines.

 

* Repeat this for the other fields as needed.

 

* In the far left column are the BTypes.  You start with a which is nonfiction.  Change the first a to read Book.  (Yes, I know you didn't have to do that in printing via List Records, but you need to do it here for exporting.)

 

* Go down the list, changing all the as to Book.  Excel tends to secondguess you and fill in for you.

 

* When you get to the b lines, those would be fiction, right?  You can put Book for them as well.

 

* What is that "t" doing in there?  Well, as you moved over the Title column, you revealed that this is a DVD.  So, you can just put DVD in there instead of Book.

 

* Now go up to the Excel toolbar and click the Page layout tab.  Then click the Page Setup (the slightly darker bar along the bottom of that section) at the far right where the little page-and-arrow icon is.

 

You'll get the Page Setup popup window.

 

* Page tab: For this report, it would probably look better in Landscape mode.

 

 

* Margins tab: The top should be 1 inch, so it can be punched and put in a binder.  All the others can come down to about 1/2 an inch (say, 4.5 or .5).  You can't reliably do much less because most printers usually need about that much blank space before they can print anyway, and that's a decent margin.

The footer can be set to 0 (zero) but leave the header at 0.3 because we'll use it.

 

 

* Header/Footer tab: Click Custom Header.

 

* In the left box, click the calendar (left of the clock) and the clock.  That dates the report.

 

* In the center, enter your title starting with your name, followed by "French Literature".

 

* In the right box, click on the page with the # so each page has a page number.  Click on OK.

 

 

If you prefer, you can put "Page" and space and then the page number, or even put Page &[Page] of &[Pages] (say, Page 2 of 5 pages will show up on page 2 if you have 5 pages total).

 

* Sheet tab: click on Rows to repeat at top and see the spreadsheet come up with a little popup on it.  Click on row 1 that starts with the column title (BType, etc.) and see the code for this appear in the popup.  Click on the X to close it and it fills it in on the form.

 

* Check Gridlines as they make it easier to keep things clear.

 

Black and white is only if you used color for something.

 

Row and column headings would be 1, 2, 3, and A, B, C which aren't very useful, so don't click on them.

 

* Click (in this case) on Over, then down as that makes it easier to line things up.  It doesn't matter that much for this short a report, but it can be helpful for longer ones.

 

 

* Click on Print Preview to see if you like the results.  Feel free to experiment with the settings if you like, if you know Excel well enough.

 

If you like, you can change the BStatus column hyphens to "Available".  If you had mixed materials, you could change the i to eBook, the o to "on order" and so forth.

 

You can also import data into word processing in this manner (in which case definitely use the tab delimited format for Word), but you get each field on a different line.

 

In word processing, you might be able to change the @ symbol into a code, such as a line break.

The reason I put the ^ in a 945 field in the records is so that I can use WordPerfect to convert the ^ into a page break between records.  (Another enhancement I'm continuing to request!)

 

You can just feel yourself getting smarter, can't you? 

 

PLEASE PLEASE PLEASE comment on this or email me if anything isn't clear.  This is intended to be as self-training as possible, but it's certainly open to suggestions for improvements.  (An improvement is not "make it easier" because it can't be easier... maybe clearer, but that's about it.  I need specific details on what you want.)

 

Additional Resource

Create Lists Troubleshooting Guide is available from CSDirect.  This file has been saved for Boreham Library staff only -- Use the Section 2 information in the wikiwords file on the N drive.]

This will help with figuring out the Boolean formulas for getting data.

 

 

Drafts

 

 

Draft 1

Draft 2