I am trying to make a comparison chart for all WO's submitted each month to all the WO's that are rejected each month. But Access comes up with some different type of error every time I try a different alternative. I have been trying to do this in a cross tab query but it is not working.
SELECT EWOSubmittedqry.EWOnumber, EWOSubmittedqry.firstlevelEWOaction
This query will return the results but not convert into the chart. If I combine this query and one that just shows the rejected EWO's than it shows all the EWO's as being rejected.