Link to home
Create AccountLog in
Avatar of prosit
prositFlag for United States of America

asked on

SQL Group By

Hi...

(Access 2010)

I'm trying to get values to group by a date, but it won't let me, please tell me what i'm missing?

SELECT DSPENT,  Fee1, Fee2
FROM qry13_1
GROUP BY DSpent

I want the data for both to be listed under the actual month (one line per month/year with the total)

Query13_1:

DSpent                        Fee1      Fee2
March 2013      $5.00      $0.00
March 2013      $5.00      $0.00
April 2013                        $0.00      $1.00
April 2013                         $5.00      $0.00

tnx
~j
ASKER CERTIFIED SOLUTION
Avatar of prosit
prosit
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account