Re: Multiple date formats in a Table
From: harvestman (anonymous_at_discussions.microsoft.com)
Date: 04/14/04
- Next message: harvestman: "Attention Andrew Smith: running query module"
- Previous message: Jeff Lane: "3800 excel forms to make into table"
- In reply to: Andrew Smith: "Re: Multiple date formats in a Table"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 13 Apr 2004 22:54:23 -0700
Second edited re-send of two previous postings.
OK... Andrew.
Once again, many thanks for your prompt reply.
A few final (?) remarks:
Athough you suggest doing the conversion of my original
text field data (into date/time) as a query, I shall
first try to copy all the date data values into another
duplicate field column (as "text" by default), then run
the query on that field... in case there are any
hiccups. Because of the problem with my dates (and not
being able to sort them), I have not added in the data I
need for another crucial couple of fields and have not
yet tried doing any queries... though I know that this
latter query function is one of the many aspects that
makes Access so valuable as a db tool.
I shall do some coding and experimentation as a module in
a query and in the next few days and see how / what
works. I have my regional settings (under control Panel)
set to dd-mmm-yyyy, i.e., in UK format. In regards to
having unrecognisable formats set to 01-Jan-1900, I'm
wondering in light of your response whether I should
arbitarily set a date that precedes my data set (but this
would be stored as a negative date number by Access)...
say 01-Jan-1850 perhaps. Re-examining my db, I have
found a record going back to 1871 and in recent
historical research, I located a reference for one of my
cave invertebrate beasties being found in the early
1860's.
BTW: I sometimes try to send copies of my latest version
of my research db to myself on email (from Uni to home),
though my home based XP version of Outlook deletes
attachments with ".mdb" file suffixes.
Is it possible to request a copy of your genealogy db? I
realise that would mean having to give you my IRL name
and email address which might not be acceptable protocol
for this newsgroup forum.
Cheers again,
harvestman.
>-----Original Message-----
-----Original Message-----
From: "Andrew Smith" <andydsmith@ntlworld.invalid>
Sent: 4/9/2004 3:01:41 PM
Subject: Re: Multiple date formats in a Table
>Harvestman,
>
>My ISP's news service has become steadily worse and you
>latest message has
>not appeared. However I knew it was there as I saw
>John's reply to it.
>
- Next message: harvestman: "Attention Andrew Smith: running query module"
- Previous message: Jeff Lane: "3800 excel forms to make into table"
- In reply to: Andrew Smith: "Re: Multiple date formats in a Table"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
