L
link9404
I'm very new to MS Access (been using it for about a day now) but need
it for a project. I have two forms that enter data into two tables.
The only data in common between the two tables is a "Team Number." I
have a nice report that combines the data from both the tables into
one entry per team number. However, on Table1, I have multiple entries
for some of the teams. Table 2 only has one entry per team number.
What happens is each team gets listed once per entry in table one and
has the same values for the things from Table 2.
For example:
Table1 has columns A B and C
Table2 has columns D E F
Team Number 25 has two entries in Table1:
Entry1-(A=2 B=3 C=Good)
Entry2-(A=5 B=2 C=Bad)
Team Number 25 has one entry in Table2:
(D=9 E=Blue F=Table)
The report says the following:
Team:25
A: 2
B: 3
C: Good
D: 9
E: Blue
F: Table
Team 25:
A: 5
B: 2
C: Bad
D: 9
E: Blue
F: Table
I would like a way of making it put all the information in one report
entry so it would say something like this:
Team 25:
A: 3.5
B: 2.5
C: Good, Bad
D: 9
E: Blue
F: Table
A, B, and D are being averaged and C is a list of all the entries
('Good' and 'Bad')
In my actual table the text a few sentences long so I can't designate
a number to it.
As I said, I am very new to Access so any help would be greatly
appreciated.
Thanks
it for a project. I have two forms that enter data into two tables.
The only data in common between the two tables is a "Team Number." I
have a nice report that combines the data from both the tables into
one entry per team number. However, on Table1, I have multiple entries
for some of the teams. Table 2 only has one entry per team number.
What happens is each team gets listed once per entry in table one and
has the same values for the things from Table 2.
For example:
Table1 has columns A B and C
Table2 has columns D E F
Team Number 25 has two entries in Table1:
Entry1-(A=2 B=3 C=Good)
Entry2-(A=5 B=2 C=Bad)
Team Number 25 has one entry in Table2:
(D=9 E=Blue F=Table)
The report says the following:
Team:25
A: 2
B: 3
C: Good
D: 9
E: Blue
F: Table
Team 25:
A: 5
B: 2
C: Bad
D: 9
E: Blue
F: Table
I would like a way of making it put all the information in one report
entry so it would say something like this:
Team 25:
A: 3.5
B: 2.5
C: Good, Bad
D: 9
E: Blue
F: Table
A, B, and D are being averaged and C is a list of all the entries
('Good' and 'Bad')
In my actual table the text a few sentences long so I can't designate
a number to it.
As I said, I am very new to Access so any help would be greatly
appreciated.
Thanks