I have [tbl1] that is one line per [ID] with fields [Jur1] to [Jur9] (Short Text) which are related to fields [Per1] to [Per9] (Number).
ID Jur1 … Jur9 Per1 … Per9 1 00 99 1 0.8 2 99 00 0.5 0.8 3 80 S5 1 1 4 A5 00 0.8 1
I made [tbl2] that has Field [JurT] with records 1-9 to make a [que1] with IDs listed 9 times and sorted by [ID] then [JUR].
ID JurT Jur Per 1 1 00 1 1 9 99 0.8 2 9 00 0.8 2 1 99 0.5 3 1 80 1 3 9 S5 1 4 9 00 1 4 1 A5 0.8
Then I have [tbl3] relates [UID] to [ID]
Then make [que2] groups by [UID] [Jur] and sum [per]. Sort by [UID] then [JUR]. ?????How do I number [Jur] 1-9 per [UID] to get back to original format [JurT2]??????
UID ID 1 1 1 2 2 3 2 4
To get back to this format using iif statments in Jur and PER.
UID Jur Per JurT2
1 00 2 1 1 99 1.3 2
2 00 1 1
2 80 1 2
2 A5 0.8 3 2 S5 1 4
UID JUR1 JUR2 JUR3 JUR4 … JUR9 PER1 PER2 PER3 PER4 … PER9 1 00 99 2 1.3 0 0 0 0 2 00 80 A5 S5 1 1 0.8 1 0 0
I have tryed to use DCount but I get lost in the is ' " [ "*" jargon. Please explain why " or [ are used.
Thanks