[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>