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

Why total

Status
Not open for further replies.
chevyimpala

chevyimpala

Programmer
Dec 19, 2003
37
US
Why would this calculation give me a total of two columns instead of a single sum:

Unreal: IIf([Current Pos]=0,0,Sum(IIf([Curr]="EUR" Or [Curr]="GBP",[Size]*-1*[Rate]+([Size]*[Revalrate]),IIf([Curr]="CHF" Or [Curr]="JPY",[Size]*-1/[Rate]+([Size]/[Revalrate]),IIf([Curr]="EUR/JPY" Or [Curr]="EUR/GBP",[Size]*([Revalrate]-[Rate])/[Rate])))))

help:(
 
Sort by date Sort by votes
Not sure what you mean by it is giving you a total of two columns. Do you mean you are getting two values? If so, it is probably because of another field on your query list. The other field probably has two values and so this calculation is calculating according to that grouping.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Better approach than Dcount to display total records? 2
Replies
3
Views
96
Moss100
Moss100
puforee
  • Locked
  • Question
Update a table based on a totals query of another table 2
Replies
16
Views
181
puforee
puforee
Lhuffst
  • Locked
  • Question
Date code adds a day but why??? 2
Replies
13
Views
104
Lhuffst
Lhuffst
Moss100
  • Locked
  • Question
Should calculated table fields ever be used - if not - why not? 1
Replies
3
Views
102
1DMF
1DMF
keun
  • Locked
  • Question
Why am I getting a Type Conversion Error when importing text into a text field?
Replies
17
Views
286
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top