MS Access Expr1 if then help?

Posted on 2003-03-08
Medium Priority
Last Modified: 2008-02-26
in basic it would look like this

if A = 0 then B else B/A
what would I do to get this to work in access I have try everything I can think of? please help
I got it
CPTW: (IIf([numberof]=0,[Purchase Price],[Purchase Price]/[numberof]))
do not answer this question
Question by:kewitt
1 Comment

Accepted Solution

SpideyMod earned 0 total points
ID: 8094970
PAQ'd and points refunded.  Answer is in the question text.

In the future, if you answer your own question, please post it as a comment rather than edit the title.  Thanks.

Community Support Moderator @Experts Exchange

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question