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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto fill not working 2
Info Not updating in table when calculation done in form. 6
Datediff on form and subform 6
Please help 1
Auto fill today's date when checkbox checked 3
How do i use a combo box or drop down list to preform a calculatio 1
Field Doesn't Show any Data for User 3
Questions about access 1

Back
Top