Hi.
I'm trying to create a report with a chart in it, based on a query. I've been using the Report Chart Wizard, but not getting the results I want. I managed to get 1/2 way there, but the bizarre thing is that when I look at the report/chart in Design view, all I see is the sample chart (the one with north east south and west), when I go back into Print Preview, it is then picking up my data.
The database is recording an application process. The chart is supposed to show in any given time period how many applications were sent out, and how many were recieved back.
The data is acheived by using a parameter query to acheive the date, and then counting the sent and received columns. Once the chart is produced, I need it to show which dates the chart applies to.
I've attached the basis of the database. - i've deleted the reports i'd produced becuase they were complete rubbish.
I have looked on line at various websites (including links i've found on this site), but nothing has helped so far.
Any guidance would be much appreciated
Thanks
I'm trying to create a report with a chart in it, based on a query. I've been using the Report Chart Wizard, but not getting the results I want. I managed to get 1/2 way there, but the bizarre thing is that when I look at the report/chart in Design view, all I see is the sample chart (the one with north east south and west), when I go back into Print Preview, it is then picking up my data.
The database is recording an application process. The chart is supposed to show in any given time period how many applications were sent out, and how many were recieved back.
The data is acheived by using a parameter query to acheive the date, and then counting the sent and received columns. Once the chart is produced, I need it to show which dates the chart applies to.
I've attached the basis of the database. - i've deleted the reports i'd produced becuase they were complete rubbish.
I have looked on line at various websites (including links i've found on this site), but nothing has helped so far.
Any guidance would be much appreciated
Thanks
