Advertisement

06.03.2008 at 09:14AM PDT, ID: 23453707
[x]
Attachment Details

Sum debits and credits in a query

Asked by howcheat in Microsoft Access Database

Tags: MICROSOFT, ACCESS, 2003, UNION QUERY OF DEBITS AND CREDITS

I have extracted data in a query from our huge database with accounting amounts located in the trans_amounts field. Some amounts are negative and some are positive. There is a field called dr_cr Ind that has C for credits and D for debits. The amounts themselves are all positive. How can I get my query to change the credits to negative so that when I export to MS Excel I can get the sum of the negatives and positives? Start Free Trial
[+][-]06.03.2008 at 09:17AM PDT, ID: 21701930

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.03.2008 at 09:19AM PDT, ID: 21701951

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Access Database
Tags: MICROSOFT, ACCESS, 2003, UNION QUERY OF DEBITS AND CREDITS
Sign Up Now!
Solution Provided By: capricorn1
Participating Experts: 2
Solution Grade: A
 
 
[+][-]06.03.2008 at 09:26AM PDT, ID: 21702018

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628