ENTER DATA IN FORM SHOW UP IN A TABLE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help Someone!

I have a table set up with Date, Month, Day of the Week fields. I have a
form that connects to that table. In the Form, I have an expression for the
Day of the Week and the Month to populate automatically.

I can see the Month and Day of the Week pop up on the form after I enter the
Date. However, the Month and Day of Week are not translated into the table. I
want the information stored in the table to run queries on those statistcs.

I'm using the following formula in the Control Source area of Properties in
the Form Design View: =Format([M:Date],"ddd")

Does anyone know how I can get that to show up in the corresponding table?

thanx
 
Why would you store that in your table? That would be redundant and waste
space.

Just store the date.

In your forms, reports, and queries you can easily display the various forms
of that date.

You should not be storing the same data in multiple formats in a table.
 
Back
Top