If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Expressions in a table
--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 |
#2
|
|||
|
|||
Expressions in a table
On Sat, 24 Jan 2009 16:41:01 -0800, Don C
wrote: --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! -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|