Count with date as criteria

H

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?
 
M

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.
 
Top