AccessQuestions
Registered User.
- Local time
- Today, 07:23
- Joined
- Jan 13, 2014
- Messages
- 15
I have a query with four fields: VideoGame, Date, GamesSold, MCScore. I want to graph the games sold and metacritic score for each game vs the date.
The easiest way I could think to do this would be in the detail section of a report so that it would automatically duplicate the graph for each game. However, it isn't working. Since I have multiple dates(ie records) for each game - the report is trying to generate way to many graphs and can't handle it. Since each record only has one date associated with it, it isn't coming out correctly either.
I was going to chunck the games into sections of 12-20 with each query to try and get the report to be able to work. Any ideas you have would be welcome. Thank you
The easiest way I could think to do this would be in the detail section of a report so that it would automatically duplicate the graph for each game. However, it isn't working. Since I have multiple dates(ie records) for each game - the report is trying to generate way to many graphs and can't handle it. Since each record only has one date associated with it, it isn't coming out correctly either.
I was going to chunck the games into sections of 12-20 with each query to try and get the report to be able to work. Any ideas you have would be welcome. Thank you
