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

Re: Access Database Question



On Sat, 22 Jan 2000, Joy Kingsolver wrote:
In Intuit's  bookkeeping software  2000 is being acknowledged by '00, i.e. 
1/21/'00.  This might also  work in your find and replace to restore your
chronological order (although I admit I haven't tried it).

 Margaret Graham

> 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

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>