Expressions in a table

[Don C]

--I need some help on a table expression. I have a table with the following
fields:
[Date Worked] [Monday Date] [Tuesday Date] [Wednesday Date] [Thursday Date]
[Friday Date]
[Saturday Date] [Sunday Date]. I need to make [Date Worked] equal to all the
other fields. I have a form that has [Monday Date], [Tuesday Date],
[Wednesday Date], [Thursday Date], [Friday Date]
[Saturday Date], [Sunday Date] on it. I tried to make the fields [Date
Worked] but when I entered a date in the first field in the form it put the
date in all the fields on the form. Each record has only one of the other
fields [Monday Date] thru [Sunday Date] that it refers to but I need to
reference them all. Is this possible?

Don C

 

[John W. Vinson]

--I need some help on a table expression. I have a table with the following
fields:
[Date Worked] [Monday Date] [Tuesday Date] [Wednesday Date] [Thursday Date]
[Friday Date]
[Saturday Date] [Sunday Date]. I need to make [Date Worked] equal to all the
other fields. I have a form that has [Monday Date], [Tuesday Date],
[Wednesday Date], [Thursday Date], [Friday Date]
[Saturday Date], [Sunday Date] on it. I tried to make the fields [Date
Worked] but when I entered a date in the first field in the form it put the
date in all the fields on the form. Each record has only one of the other
fields [Monday Date] thru [Sunday Date] that it refers to but I need to
reference them all. Is this possible?

Don C

As noted in your other thread - this table structure is simply INCORRECT.

It really sounds like you're working exclusively in the Form. Again... you
can't store data in a form; you don't design your table in a form. You
structure your tables *first*, and then design the form to fit the table - not
vice versa. If you have seven *controls* (forms don't have fields, tables do)
all bound to [Date worked] then yes, they'll all show the same value,
regardless of the label on the control - because the data is in the field
named Date Worked in the table, not on the form!

Again: where did you get this template? I'd be willing to look at it to see if
it's possible to correctly normalize it - but it appears to be wrong in its
basic conception!