Preforming Access calulations

  • Thread starter Thread starter smarque
  • Start date Start date
S

smarque

I'm trying to enter a date in one field and have the day auto fill a second
field. How do I do this?
 
I'm trying to enter a date in one field and have the day auto fill a second
field. How do I do this?
Click to expand...

In a Table? You don't, and you needn't.

Tables are NOT spreadsheets, and do not support calculations; and you should
not store any data which can be calculated.

To display the day, just use two textboxes on your form or report, bound to
the same date field; set the format of one to Short Date (or whatever format
you prefer), and the format of the other to "dddd" to display Saturday or
Tuesday.

If you're interacting with your data in a table datasheet... don't. That's not
their function; use a Form instead.
 
Back
Top