?
Solved

Repeating dates on Access report

Posted on 2011-09-14
3
Medium Priority
?
196 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 93

Accepted Solution

by:
Patrick Matthews earned 2000 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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

764 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