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

Re: Access Database Question



Wow, this must be a first, a pleasant surprise from a Microsoft product:)

By all means, then, do it within the database.

User of many databases, absolute master of none,
Chuck

On Sat, 22 Jan 2000, Joy Kingsolver wrote:

> You can do these "Find & Replace" operations in Access, so why
> export it into a text file?
>
> Joy Kingsolver
> Chicago
>
> On Fri, 21 Jan 2000, Chuck Thomas wrote:
>
> > I think your best option is to export the database into a text file, then
> > use successive search replace commands to replace
> >
> > "00." with "2000."
> > "99." with "1999."
> > "98." with "1998."
> >
> > and so forth. Before you import it back into Access, make sure your # of
> > characters is adjusted to accommodate the extra digits you will now have.
> >
> > Good luck.
> > Chuck
> >
> > At 07:17 PM 01/21/2000 -0500, you wrote:
> > >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>
> > >
> > >
> > ********************************************************
> > Question to Elvis: "What kind of girls do you prefer?"
> >
> > Elvis: "Female mostly."
> >
> >   --From THE QUOTABLE KING
> >     (Nashville: Cumberland House, 1997)
> >
> > "Qui me amat, amet et canem meum" (Love me, love my dog)
> >  - A proverb mentioned by St. Bernard in his SERMO PRIMUS
> >
> > Charles F. Thomas
> > Special Collections/Archives Technical Services Librarian
> > Univ. of Minnesota Libraries
> > 612-625-3036
> > thoma134@tc.umn.edu
> > ********************************************************
> >
> > 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>
> >
>
> 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>
>

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>