Darrell
Registered User.
- Local time
- Today, 18:32
- Joined
- Feb 1, 2001
- Messages
- 306
Hi guys,
I have an issue with my soccer db which has happened for the first time ever and it has got me stumped.
When I report the weekends game in my db, I enter the results for the division into the main form and when my team is selected, I enter the goal scorers name and the number of goals in a subform. I also enter in the MVP points into another subform.
In a query I have the results for our team and I have wedged in the goal scorers and the MVP into this also. This means that the same data appears in the query for each goal scorer but that is ok as I just do a hide duplicate values in the report and it all looks fine.
The trouble is that last week, we failed to score a goal for the first time in over two years, and therefore there is a null value in the scorers table for that record and so my query is not reporting anything.
Can anyone shed some light on what I should try?
dh
I have an issue with my soccer db which has happened for the first time ever and it has got me stumped.
When I report the weekends game in my db, I enter the results for the division into the main form and when my team is selected, I enter the goal scorers name and the number of goals in a subform. I also enter in the MVP points into another subform.
In a query I have the results for our team and I have wedged in the goal scorers and the MVP into this also. This means that the same data appears in the query for each goal scorer but that is ok as I just do a hide duplicate values in the report and it all looks fine.
The trouble is that last week, we failed to score a goal for the first time in over two years, and therefore there is a null value in the scorers table for that record and so my query is not reporting anything.
Can anyone shed some light on what I should try?
dh