M
Mike
Hopefully someone can help me with this. I've been trying to make a graph of
the number of records that meet certain criteria grouped by month. For
instance, I want two seperate lines of the graph to be a count of the records
that have two different boolean fields that are equal to true and a third
line that is a count of the total amount of records. These are both gonna be
grouped by month. So the x axis is the month and y axis is the count. I've
tried a few things to get this to work with no luck. I was able to get a
graph made using a crosstab query to count the total records grouped by
month, but I can't do the same thing with the boolean fields for the other
lines on the graph. I think if I was able to get the counts by month into a
query I would be able to make the graph from that. Any help is much
appreciated. Thanks.
the number of records that meet certain criteria grouped by month. For
instance, I want two seperate lines of the graph to be a count of the records
that have two different boolean fields that are equal to true and a third
line that is a count of the total amount of records. These are both gonna be
grouped by month. So the x axis is the month and y axis is the count. I've
tried a few things to get this to work with no luck. I was able to get a
graph made using a crosstab query to count the total records grouped by
month, but I can't do the same thing with the boolean fields for the other
lines on the graph. I think if I was able to get the counts by month into a
query I would be able to make the graph from that. Any help is much
appreciated. Thanks.