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

Exclude 0 from calculation?

Status
Not open for further replies.
MaddiMond

MaddiMond

Technical User
Mar 28, 2005
76
US
I have a control in a report that calculates an Average Avg([Margin]). How can I exclude 0 from this calculation?
IIf ([Margin]=0, ??

Thanks,

Maddi
 
Sort by date Sort by votes
You can use Not Like 0 or <> 0 in the criteria query.
 
Upvote 0 Downvote
but WHY exclude the values? Of course they skew the results. But then if you (the boss, whomever, ... ) really want the avg margin, stuff with no markup reallt DOES have an effect on that!




MichaelRed


 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Question
Query expression negative to a 0
Replies
6
Views
307
dhookom
dhookom
serino
  • Locked
  • Question
Delete From Table
Replies
1
Views
734
Andrzejek
Andrzejek
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
541
mikrom
mikrom
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
4K
lameid
lameid
MDGarcia
  • Locked
  • Question
Error Could not delete from specified tables 2
Replies
14
Views
1K
MDGarcia
MDGarcia

Part and Inventory Search

Sponsor

Back
Top