Next, I have a form called "form1"
On this form there are two fields which lets the user enter in beginning date and end dates to retrieve records.. After the user types in dates.. he hits a button which counts the first two letters of the field "INSP" in table "tblInspections"...
So if the user leaves the dates fields blank ( which would retrieve all records in table "tblInspections" ) the output should look like so:
total = 17
The output here is stored in a query called "query3"
Still on "form1" .. I created a pie chart which displays the contents of "query3"..
So after the user enters in dates and hits the button.. A chart is displayed of "query3"
No problems so far there...
I have spoken with the users of the program and they want to add sections to this pie chart..
"Civil" - Civil is a count of all AB + CO, so in the above example I would get a number 5 to graph. Since Civil is AB + CO, I will not need to show AB or CO anymore so how can add civil and take away AB and CO ?
"Welding" - This section would consist a count of all PF98 + PS98, From the example above Welding = 2
"Hydrotest" - This section would consist a count of all PF29 + PS20, From the example above
Hydrotest = 2
"Piping" - The remaining PF and PS that does not have PF98, PS98, PF29 or PS20 would be classified here...
Piping = 3
After all that my query should look something like this to be graphed:
total = 17
My question would to be how to add those section to my chart leaving the total to be the same.
i think that u can you iif Funcation with in the Qruey 3 , where 1 of the field is like exp: iff() the use string compare funation to get ... cilivl and all the other info... then do pie chart on that...