Sum, group, date

[Guest]

I am query for data between two dates (11/1/04 and 12/31/04) and group the
data. My results bring up [names], [num] and [dates].

Bob 2 11/14/04
Bob 3 11/15/04
Will 4 12/1/04
Will 3 12/2/04

I want to sum Bob and Will, 5 and 7. The date criteria is affecting the
summing of the [num]. How do I solve this problem?

Thanks

 

[Duane Hookom]

Provide your SQL.
Tell us what is wrong with your results.

 

[Guest]

I made a mistake. I should be using "WHERE" in "GROUP BY" in the statement.

Provide your SQL.
Tell us what is wrong with your results.

--
Duane Hookom
MS Access MVP
--

I am query for data between two dates (11/1/04 and 12/31/04) and group the
data. My results bring up [names], [num] and [dates].

Bob 2 11/14/04
Bob 3 11/15/04
Will 4 12/1/04
Will 3 12/2/04

I want to sum Bob and Will, 5 and 7. The date criteria is affecting the
summing of the [num]. How do I solve this problem?

Thanks