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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Difference

Status
Not open for further replies.
LJA520

LJA520

Programmer
Nov 3, 2003
65
US
Hello!

Is there a function that will subtract a group of numbers and find the differce. I am trying to find the difference of number's in a detail line on a report. Any ideas???

Thank you in advance,
LJA
 
Sort by date Sort by votes
we could make you a VBA function
Need more specifics though.

example of what numbers and what you mean by differnce.

DougP, MCP, A+
 
Upvote 0 Downvote
Hi DougP,

I have a report and on each line (the detail line) there is a total, but at the bottom of the report I would like to get the grad total difference of all those totals. By subtracting each total from eachother. Is this possible?

Thank you very much!
LJA
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

timoteo
  • Locked
  • Question
Cannot Average Time Difference 2
Replies
7
Views
43
timoteo
timoteo
straybullet
  • Locked
  • Question
Calculated difference between same field, diff records? 1
Replies
3
Views
46
Remou
Remou
katrina63
  • Locked
  • Question
Difference Between highest date & lowest date. 1
Replies
2
Views
29
dhookom
dhookom
TCar
  • Locked
  • Question
Subtraction / Difference ?? 1
Replies
1
Views
18
PCLewis
PCLewis
rjaber
  • Locked
  • Question
Report showing difference between dates and average 2
Replies
4
Views
26
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top