Repeating dates on Access report

I have a report in Access 2007, It repeats dates, for example
Date    Qty
9/12    352
9/12      25

9/19     56
9/19     36

How can I only get the date once and the total Qty?  Do i do it on report? or on the query?

thanks
drasmuss70Asked:
Who is Participating?
 
Patrick MatthewsCommented:
I'd do it in the query. Something like:

Select MyDate, Sum(Qty) AS TotQty
From MyTable
Group By MyDate
0
 
Jeffrey CoachmanMIS LiasonCommented:
<No Points wanted>

I would go with what matthewspatrick posted.

You can do this in the report, but it requires a lot of design view machinations if the report is not already grouped by the day...
0
 
drasmuss70Author Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.