Any help please.I would like for a field to come up in my database in
relation to the date i enter but i would like the day field to show the day
of the week.(in another field)

Thanks
antenna (AT) bigpond (DOT) net.au

Hi:
Assume the text box into which you put the date is Text0.
The the formula in the second box is:
=WeekdayName(Weekday([text0]))
Weekday returns a number so you need both functions.
Default the Text0 box to a vaid date (or NOW()) or you will get an
error in the second box when you open the form.

Good Luck
Ira Solomon

On Thu, 01 Jan 2004 10:02:29 GMT, "Grahame" <antenna (AT) bigpond (DOT) net.au>
wrote: