[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Access Database Question



Greetings:

We have an Access database for our collection & are experiencing
problems w/ sorting. We number our accessions by year then number of
each collection. So one collection accessioned in Dec. 99 would read
99.0635, the next 99.0636 and so on. This month we've started with 2000
as 00.0001, 00.0002 and so on. But when we tell Access to place into
order 00.0001 is at the top and all the ones from previous years
underneath, so our screen or printout reads all the accessions arriving
this year, then all the previous years, rather than this year at the
bottom. We haven't been able to figure how to write this so it will sort
with year 2000 accessions at bottom, as this is a text file and 00.
reads smaller than 99. Any suggestions?
--
Joan E. Denman
Archival Assistant
Institute on World War II
& the Human Experience
Department of History
Florida State University
Tallahassee, FL 32306-2200
silver2@tdo.infi.net

A posting from the Archives & Archivists LISTSERV List!

To subscribe or unsubscribe, send e-mail to listserv@listserv.muohio.edu
      In body of message:  SUB ARCHIVES firstname lastname
                    *or*:  UNSUB ARCHIVES
To post a message, send e-mail to archives@listserv.muohio.edu

Or to do *anything* (and enjoy doing it!), use the web interface at
     http://listserv.muohio.edu/archives/archives.html

Problems?  Send e-mail to Robert F Schmidt <rschmidt@lib.muohio.edu>