Count with date as criteria

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hotplate74@gmail.com - 14 Aug 2006 16:34 GMT

I am doing a count of defects in a query, whenever I try to do a date
range as criteria, 2 defects that are the same are broken into 2
instead of grouped together. The query works fine until I try to do a
between start date and end date. How can I do a date range without 2
identical defects being counted as 1 and 1?

Reply to this Message

Mike - 14 Aug 2006 16:45 GMT

When you say "2 defects that are the same are broken into 2 instead of
grouped together." are you trying to see this as a single entry in your query?
If this is the case then switch to the SQL view of your query in design and
type "destinct" folloed by a space just after the word "Select" and save the
query.
Let me know if this helps.

> I am doing a count of defects in a query, whenever I try to do a date
> range as criteria, 2 defects that are the same are broken into 2
> instead of grouped together. The query works fine until I try to do a
> between start date and end date. How can I do a date range without 2
> identical defects being counted as 1 and 1?

Reply to this Message

hotplate74@gmail.com - 14 Aug 2006 16:54 GMT

I think I figured it out, I needed to do a count by date instead of
"group by"

> When you say "2 defects that are the same are broken into 2 instead of
> grouped together." are you trying to see this as a single entry in your query?
[quoted text clipped - 8 lines]
> > between start date and end date. How can I do a date range without 2
> > identical defects being counted as 1 and 1?

Reply to this Message