Harry Taylor
Registered User.
- Local time
- Today, 19:39
- Joined
- Jul 10, 2012
- Messages
- 73
Please help.
I come from an Excel background so am probably doing this wrong, however . . .
I have a Table [RA], in the table i have a fields [Install], [SC], [SCCB]
This is in date order and totals what an engineer has accomplished each day. for example [Install] 1, [SC] 6, [SCCB] 2
I have another Table [Score] with the same fields with a score rating i.e [Install] is 7, and [SC] is 1 [SCCB] is 1
In Table [RA] i want a field that multiplies [Install] by the [Score] [Install]. This would give a daily score, so 1 Install (7) is the same as 7 SC's (7)
Hope that makes sense
From an Excel point of view something like this;
=Sum([RA] [Install] * [Score] [Install]) , ([RA] [SC] * [Score] [SC]) , ([RA] [SCCB] * [Score] [SCCB])
Any ideas?
Thank you in advance
I come from an Excel background so am probably doing this wrong, however . . .
I have a Table [RA], in the table i have a fields [Install], [SC], [SCCB]
This is in date order and totals what an engineer has accomplished each day. for example [Install] 1, [SC] 6, [SCCB] 2
I have another Table [Score] with the same fields with a score rating i.e [Install] is 7, and [SC] is 1 [SCCB] is 1
In Table [RA] i want a field that multiplies [Install] by the [Score] [Install]. This would give a daily score, so 1 Install (7) is the same as 7 SC's (7)
Hope that makes sense
From an Excel point of view something like this;
=Sum([RA] [Install] * [Score] [Install]) , ([RA] [SC] * [Score] [SC]) , ([RA] [SCCB] * [Score] [SCCB])
Any ideas?
Thank you in advance