Solved

Repeating dates on Access report

Posted on 2011-09-14
3
191 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
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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
User Level Security 6 39
Access on Mouse move 5 36
Should I keep recordsets open? 3 26
Cascading Combo boxes between 2 sub navigation forms 1 16
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

825 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