colinmunnelly
04-18-2002, 09:40 PM
Hope you can help.
I want to make a simple chart based on data from multiple queries. For example, i have one table only consisting of 3 columns, first job description, second is complete, and third incomplete. When a job is done the word yes or a date is placed in the complete column. I want to show on a chart 3 lines one showing the amount of jobs in total. Another showing jobs complete and the other showing jobs incomplete. I think i need to combine 2 queries to get the correct data.
Any help be great
Thanks
I want to make a simple chart based on data from multiple queries. For example, i have one table only consisting of 3 columns, first job description, second is complete, and third incomplete. When a job is done the word yes or a date is placed in the complete column. I want to show on a chart 3 lines one showing the amount of jobs in total. Another showing jobs complete and the other showing jobs incomplete. I think i need to combine 2 queries to get the correct data.
Any help be great
Thanks