Count with date as criteria

[hotplate74]

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?

 

[Mike]

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.

 

[hotplate74]

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