View Full Version : multiple query and chart problem


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

KKilfoil
04-19-2002, 05:26 AM
You have posted same question under different subject in General forum.

Please pick one forum and stick with it, as responders have no easy way to know what has already been suggested, rejected, etc.