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!

EXPRESSION: FORMAT ???

Status
Not open for further replies.
RookieDBO

RookieDBO

Technical User
Sep 20, 2001
83
CA
I build an expression that does a division calculation. Now I need to format the output with 0 decimal. Please help.

OH QTY: Sum([Yogurt Report]![BILL OH QTY]/[Yogurt Report]![CURR FCST QTY])


Thanks,
RookieDBO

 
Sort by date Sort by votes
Int(Sum([Yogurt Report]![BILL OH QTY]/[Yogurt Report]![CURR FCST QTY]))
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ptrifile
  • Locked
  • Question
Format of Date from Query 1
Replies
2
Views
101
ptrifile
ptrifile
PeDa
  • Locked
  • Question
Join on table1.var1 = -table2.var2 gives 'Join expression not supported' error
Replies
9
Views
239
combo
combo
Moss100
  • Locked
  • Question
Syntax Error (missing opertator) in query expression..... 1
Replies
5
Views
190
Moss100
Moss100
TheresAlwaysAWay
  • Locked
  • Question
Using Domain Aggregate expression in Update Query 2
Replies
12
Views
194
TheresAlwaysAWay
TheresAlwaysAWay
supportsvc
  • Locked
  • Question
Text to Format as Date? 1
Replies
5
Views
129
supportsvc
supportsvc

Part and Inventory Search

Sponsor

Back
Top