Solved

Repeating dates on Access report

Posted on 2011-09-14
3
193 Views
Last Modified: 2012-06-21
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
0
Comment
Question by:drasmuss70
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 total points
ID: 36538925
I'd do it in the query. Something like:

Select MyDate, Sum(Qty) AS TotQty
From MyTable
Group By MyDate
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36539172
<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
 

Author Closing Comment

by:drasmuss70
ID: 36560099
thanks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question