[AccessD] State/County table part 3

Gary Kjos garykjos at gmail.com
Wed Jan 2 13:42:03 CST 2013


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?

GK

On Wed, Jan 2, 2013 at 1:33 PM, Kathryn Bassett <kathryn at bassett.net> wrote:
> https://www.dropbox.com/s/xafzeh21sj6fyxu/MarriageIndex.accdb
>
> Question about date entries.
>
> I have to figure out how to enter just a year in the date field so we can
> put "2nd month, 9th day" in the notes when Quaker marriage dates are
> encountered. If it's possible, I want to be able to enter 1850 in the date
> field and have it take.
>
> Is this possible or do I need to leave it blank and put "1850, 2nd month,
> 9th day" in the notes instead?
>
>
> --
> Kathryn Rhinehart Bassett (Pasadena CA)
> "Genealogy is my bag" "GH is my soap"
> kathryn at bassett.net
> http://bassett.net
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



-- 
Gary Kjos
garykjos at gmail.com


More information about the AccessD mailing list