Hi
I am very new to access. I am starting a new job and have been asked to
design a data base.
After much messing around I have got something that is just o.k.
The problem is that every time I put a date in it displays 1899, never the
right date.
I have tried short date long date every sort of date. But it will not
display the current date.
The system date is fine.
Hope you can help thanks Andrew

How are you putting the date in? Dates are stored as numbers, and a number
of 0 corresponds to 30 Dec, 1899, so it sounds as though you're not actually
getting a valid value in the date field.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Rowlie" <rowlie.man@btinernet.com> wrote in message
news:cat50v$cqk$1@titan.btinternet.com...[color=blue]
> Hi
> I am very new to access. I am starting a new job and have been asked to
> design a data base.
> After much messing around I have got something that is just o.k.
> The problem is that every time I put a date in it displays 1899, never the
> right date.
> I have tried short date long date every sort of date. But it will not
> display the current date.
> The system date is fine.
> Hope you can help thanks Andrew
>
>[/color]