[AccessD] State/County table part 3

Kathryn Bassett kathryn at bassett.net
Wed Jan 2 17:02:15 CST 2013


Stuart said:
> If it's defined as a date field it will have to have a month and a day.
Date fields
> are actually a number containing a number of days from a starting number
> with the decimal portion indicating a number of fractional moments of a
day
> for the time. Perhaps you need to use a text field instead of a true date
format
> field?

Better to have the entire thing in the note so that people do their own
conversion. Neophyte genealogists don't know that the 2nd month is April.
Even experienced people don't know if the date has already been converted.
Like "is 9 Feb 1850 the converted date or the Quaker date (which would be
the 12th month)"? I suspected that just the year would be problematic since
what you describe is the way it works in a spreadsheet. So I think I'll just
leave the date field empty, and only put it in the notes.

Tina said:
> As  this database appears to be for marriages from a long time ago, the
> counties of today will not match the counties of yesteryear.  For
instance, in
> Michigan, counties such as Antrim and Kalkaska used to be part of Grand
> Traverse County.  If that distinction is going to matter to you, you may
want to
> look into the history of the counties in the states you are working with,
too.

Not an issue as the paper index is what the county was at the time of the
marriage. This will ultimately be an ebook and the explanations will be in
the introduction, as to which counties to find the records. This is a
collection of marriages my friend has collected through the years in various
states. She will make the ebook for purchase for a nominal sum, then if they
find the person they want, they can purchase a copy of the document. She has
hundreds of them.

Gary said:
> If it's defined as a date field it will have to have a month and a day.
Date fields
> are actually a number containing a number of days from a starting number
> with the decimal portion indicating a number of fractional moments of a
day
> for the time. Perhaps you need to use a text field instead of a true date
format
> field?

Won't work because we will also be wanting to sort by date. At least leaving
it empty will sort all the Quaker dates at the beginning.

--
Kathryn Rhinehart Bassett (Pasadena CA)
"Genealogy is my bag" "GH is my soap"
kathryn at bassett.net
http://bassett.net   







More information about the AccessD mailing list