473,322 Members | 1,409 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Sum a Total Dollar amount within a specific group

58
Sorry, this is a duplicate. Please reply the other one

Part of my Access Database has two fields that I want to work on: [Model] and [Gross]
[Model] has a drop down list with ( "A", "B", "C", etc,) options.

When I use the following expression, (in this case for Model “A”)
Code.
Abs(Sum([Table].[Gross] And ([Table].[Model]="A"))) AS [Total A Gross]

I get the count of the number of records that the Model "A" has, which is 2. Instead, my intension is to get the total Gross amount of it, which is $350.00.

Model……Gross……Gross A
A…………150.00…..…….1
A……….. 200.00.………..1
B………..375.00.…………0
C………..400.00...……...0
C……..…100.00………...0
Total……………………….2

What would it be the correct expression to get the Total Gross of each Model individual?

Something like this would be the ideal Query:

Model……Gross……Gross A……Gross B……Gross C
A…………150.00……..150……….…0……………..0
A………. 200.00………200………….0……………..0
B……….375.00………..0…………375……………..0
C……… 400.00………..0………….0……………..400
C………100.00………..0………….0……………..100
Total………………….…350………..375…………….500

If anyone can help me on this, will be greatly appreciated

plaguna
Jan 19 '09 #1
2 1230
plaguna
58
This is a duplicate thread. Deleted by Plaguna
Jan 19 '09 #2
NeoPa
32,556 Expert Mod 16PB
Is http://bytes.com/topic/access/answer...o-fields-query the other version you're referring to?

If you confirm which it is I can close this thread to further posting for you.
Jan 20 '09 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Matt | last post by:
I am running CR 8.5 from a (large) SQL Server db. My aim is to use crystal enterprise so end users in our sales team can access reports on demand for a given date range and client so I am trying...
2
by: phaddock4 | last post by:
Please help. GOAL: I hope to calculate a total amount in a TotalQuery (or field in the SubQuery?), based upon three field amounts in a SubQuery. STATUS: When I create an expression in the...
1
by: u473 | last post by:
I am scratching my head with the required quotes and parentheses. I started with an existing working Query with Running Total by date. Now I need to produce a running total by quarter day, so I...
1
by: damezumari | last post by:
How do I get the total without a condition and the total with the condition at the same time? This is my mysql table: id datetimeconfirmed customerid amount 1 ...
15
klarae99
by: klarae99 | last post by:
I am working on an Inventory Database in Access 2003. I am working on a report that I could print when its time to file our State Sales Tax paperwork. The figures I need for this report are Total...
2
klarae99
by: klarae99 | last post by:
Hello, I am working in Access 2003 on an inventory database. Right now I am working on a report which will be used to fill in forms that our state requires periodically to collect taxes. Right...
2
by: Serenityquinn15 | last post by:
Hi! I have little trouble in my Program. I need to total all the amount in specific column.. comes from the data produced by the datagrid.. heres my code: Set rs11 = New Recordset...
29
by: Nick | last post by:
I've seen a few frameworks use the following: function $(id) { return document.getElementById(id); } Then to use: $('something').innerHTML = 'blah'; I'm just trying to roll this out to my...
5
by: plaguna | last post by:
Part of my Access Database has two fields that I want to work on: and has a drop down list with ( "A", "B", "C", etc,) options. When I use the following expression, (in this case for Model...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shζllξpτpο 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.