Total amount for certain records

[Guest]

I'm trying to build an expression that will allow me to do a Total the
Amounts for APPROVED and DECLINED records in the Status field.

Anyone know how to do this?

 

[Jeff L]

You don't need an expression. You can do this with a group query.
Select Status, Count(Status)

From YourTableName

Group by Status

Hope that helps!

 

[Guest]

No, I don't want a count of the APPROVED and DECLINED. I want to Total the
dollar amount in the Amount field when the Status is APPROVED and DECLINED.

 

[pietlinden]

No, I don't want a count of the APPROVED and DECLINED. I want to Total the
dollar amount in the Amount field when the Status is APPROVED and DECLINED.

Create a totals query. Group by Status. Sum of Dollar Amount.
something like

SELECT Status, Sum(Amount) As Total
FROM SomeTable
GROUP BY Status
ORDER BY Status ASC;

Your result would look like
Status Total
Approved $213,000
Declined $185,000

 

[Guest]

I already have that. What I want is an expression that will Total the
APPROVED and the DECLINED. So, instead of having $213 for one and $185 for
the other, I want a total of $398 for both.

Thanks for your help.

 

[Jeff L]

You don't want the Approved and Declined separated, correct?

SELECT Sum(Amount) As Total
FROM YourTableName

 

[Guest]

I have that and it comes up with a total for APPROVED and a total for
DECLINED. It's not adding them together.
Field: Amount
Table: Loan Activity
Total: Sum

 

[Jeff L]

The statment I gave you will work.

Select Sum(Amount)

From [Loan Activity]

 

[Guest]

I must be missing a step, because what I get is:

Status SumOfAmount
APPROVED $10,000.00
DECLINED $87,000.00

I was thinking I could build a Total expression that would combine the two
amounts so I would get $97,000.00

The statment I gave you will work.

Select Sum(Amount)

From [Loan Activity]

I have that and it comes up with a total for APPROVED and a total for
DECLINED. It's not adding them together.
Field: Amount
Table: Loan Activity
Total: Sum

 

[Jeff L]

Take the status out of your query and you will get 97000.

I must be missing a step, because what I get is:

Status SumOfAmount
APPROVED $10,000.00
DECLINED $87,000.00

I was thinking I could build a Total expression that would combine the two
amounts so I would get $97,000.00

The statment I gave you will work.

Select Sum(Amount)

From [Loan Activity]

I have that and it comes up with a total for APPROVED and a total for
DECLINED. It's not adding them together.
Field: Amount
Table: Loan Activity
Total: Sum

:

You don't want the Approved and Declined separated, correct?

SELECT Sum(Amount) As Total
FROM YourTableName



Millie wrote:
I already have that. What I want is an expression that will Total the
APPROVED and the DECLINED. So, instead of having $213 for one and $185 for
the other, I want a total of $398 for both.

Thanks for your help.

:


Millie wrote:
No, I don't want a count of the APPROVED and DECLINED. I want to Total the
dollar amount in the Amount field when the Status is APPROVED and DECLINED.

:

You don't need an expression. You can do this with a group query.
Select Status, Count(Status)
From YourTableName
Group by Status

Hope that helps!


Create a totals query. Group by Status. Sum of Dollar Amount.
something like

SELECT Status, Sum(Amount) As Total
FROM SomeTable
GROUP BY Status
ORDER BY Status ASC;

Your result would look like
Status Total
Approved $213,000
Declined $185,000