Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Negative totals

Status
Not open for further replies.
Ben6550

Ben6550

Technical User
Jan 8, 2004
16
GB
Pretty simple solution to this prob... when i run a query using the total function to display sum of table i am recieving a negative total when i am after a posertive total number. Any solutions..
 
Sort by date Sort by votes
You may need to just use the Abs() function on your field:
SELECT Sum(Abs([YourField]))...

Duane
MS Access MVP
Find out how to get great answers faq219-2884.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Mike R
  • Locked
  • Question
Report header totals
Replies
1
Views
117
dhookom
dhookom
bcooler
  • Locked
  • Question
Summarizing data and reporting running totals by month
Replies
4
Views
111
bcooler
bcooler
RomeERome
  • Locked
  • Question
Dynamic Totals for a Crosstab Query 1
Replies
6
Views
116
dhookom
dhookom
misscrf
  • Locked
  • Question
Report totals? 1
Replies
5
Views
62
misscrf
misscrf
evr72
  • Locked
  • Question
Report Totals
Replies
1
Views
72
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top