I have a query to look at quotation success rate based on the field "quotation accepted" which is a yes no tick box field.
I have a sum query where I use the "quotation accepted" field twice in the same query. One is set to "group by" and the second is set to "count". This query works fine and counts how many times a quotation has or has not been accepted and returns to figures Count of no and count of yes. This query is used to drive a pie chart and works great!
The problem! I know want to use the same query, but this time between a date range. As soon as I add the date column to the query, it no longer works to my frustration. Obviously the structure is wrong, but whats right? What am I doing wrong? As soon as I remove the date field the query work fine!
The query still runs with the date field but returns inaccurate counting range, I only want a count of yes noe between dates.
Thanks anyone that Helps
mark
I have a sum query where I use the "quotation accepted" field twice in the same query. One is set to "group by" and the second is set to "count". This query works fine and counts how many times a quotation has or has not been accepted and returns to figures Count of no and count of yes. This query is used to drive a pie chart and works great!
The problem! I know want to use the same query, but this time between a date range. As soon as I add the date column to the query, it no longer works to my frustration. Obviously the structure is wrong, but whats right? What am I doing wrong? As soon as I remove the date field the query work fine!
The query still runs with the date field but returns inaccurate counting range, I only want a count of yes noe between dates.
Thanks anyone that Helps
mark
