Solved

Access programming

Posted on 2011-09-22
4
305 Views
Last Modified: 2012-06-21
Ok, I have this access thing I've been working on all day and I cant seem to get the formula right. Or maybe it cant do it the way I want it to.

I have a report based on a query. The query has all the information I'm looking for a needing. scenario is as follows.

Sample report of what it currently does


CustomerName     Order Number    Qty   DaysLate    Order Dollars     Dollars Late
 
ABCD                      6582                   2           30            7,000                  42,0000
Sample                    9324                   1           2              5,000                  10,000
Test                         9499                   1           5              1,000                   5,000

Sum                                                                                12,000                 52,000

What I want it to do:

CustomerName     Order Number    Qty   DaysLate    Order Dollars     Dollars Late
 
ABCD                      6582                   2           30            7,000                  42,0000
Sample                    9324                   1           2              5,000                  10,000
Test                         9499                   1           5              1,000                   5,000

Sum                                                                                12,000                 52,000
9*** Sum                                                                                                     15,000


I want to add a number at the end or another sum line to sum up every order number that starts with a 9. the 15,000 is what I want it to total for me along with everything else.

Question is 1: Do I do this in the report, or do I do this in the Query?
Question 2 is: How would the formula look.

Formula for the Dollars late summary is =Sum([Dollars Late])

I want it something like this =Sum([Dollars Late] IIf([CUST_ORDER_ID]>="9000" And [CUST_ORDER_ID]<="9999"))

I might need to provide more information, but This is a start.
0
Comment
Question by:Keef400
  • 2
  • 2
4 Comments
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 total points
ID: 36583298
Close!

=Sum(IIf([CUST_ORDER_ID] Like "9*", [Dollars Late], 0))
0
 

Author Comment

by:Keef400
ID: 36583350
AHHHH!!!! seems so simple now. I guess I was over complicating it. Thank you very much, and thank you even more for understanding what I was asking for.
0
 

Author Closing Comment

by:Keef400
ID: 36583355
Very quick, Thank you!
0
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 36583394
Glad to help :)
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

910 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now