chuck.harrison
New member
- Local time
- Today, 14:56
- Joined
- Dec 30, 2022
- Messages
- 3
Hello,
I currently have a query that has a column named MESSAGE, and another column named AMOUNT. This MESSAGE column contains text such as:
TRANSACTION DATE NOT WITHIN LP/POE DATE RANGE
TRANSACTION IS NOT ELIGIBLE TO BE APPLIED TO FINANCIAL AID
INVOICE TYPE CANNOT BE APPLIED
and so on.
I am wanting a totals page showing each message, a total count of each message, along with a sum total for each message. What I have so far is not returning anything, and i'm stumped as to what I need to do to get this to work. I'm attaching a screenshot of the query for reference.
Thank you
I currently have a query that has a column named MESSAGE, and another column named AMOUNT. This MESSAGE column contains text such as:
TRANSACTION DATE NOT WITHIN LP/POE DATE RANGE
TRANSACTION IS NOT ELIGIBLE TO BE APPLIED TO FINANCIAL AID
INVOICE TYPE CANNOT BE APPLIED
and so on.
I am wanting a totals page showing each message, a total count of each message, along with a sum total for each message. What I have so far is not returning anything, and i'm stumped as to what I need to do to get this to work. I'm attaching a screenshot of the query for reference.
Thank you