josephbupe
Registered User.
- Local time
- Today, 06:38
- Joined
- Jan 31, 2008
- Messages
- 247
Hi,
I am using a union query to generate a bar-chart based on data for year 2018 thus far. However, the query returns a wrong bar-chart when I enter a year that does not have data. For instance, open the form named "F_VENTS_STATISTICS" and enter 2017 in the prompt window; the data generated for Training does not exist; I expect to see a blank chart.
Please, i have attached a copy of the db file.
Any help is appreciated in advance.
Thanks.
I am using a union query to generate a bar-chart based on data for year 2018 thus far. However, the query returns a wrong bar-chart when I enter a year that does not have data. For instance, open the form named "F_VENTS_STATISTICS" and enter 2017 in the prompt window; the data generated for Training does not exist; I expect to see a blank chart.
Please, i have attached a copy of the db file.
Any help is appreciated in advance.
Thanks.