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

Removing #Fault , #Error from access sql query expression

Status
Not open for further replies.
Crunchy1234321

Crunchy1234321

Programmer
Jul 2, 2012
1
0
0
thread703-1248315

IIf([Quantity]=0,0,[Price]/[Quantity])
This helped but I needed to change the "," with as ";"
so the final expression is

IIf([Quantity]=0;0;[Price]/[Quantity])



 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
104
dhookom
dhookom
EwaFAMA
  • Locked
  • Question
ACCESS - Adding image from URL to the report 1
Replies
11
Views
274
EwaFAMA
EwaFAMA
renigar
  • Locked
  • Question
Access 365 Report use nickname if exist instead of 1st name
Replies
4
Views
152
renigar
renigar
caykamanj1966
  • Locked
  • Question
Open Report based on selection from a pull-down menu 1
Replies
12
Views
187
caykamanj1966
caykamanj1966
GPnew
  • Locked
  • Question
Access 2016 report export to excel column order changes
Replies
2
Views
54
GPnew
GPnew

Part and Inventory Search

Sponsor

Back
Top