[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


if expression in calculated query field

Posted on 2011-10-08
Medium Priority
Last Modified: 2012-05-12
dbse uploaded.
I want to create an expression in the Invoices query.
the expression takes a figure from the Invoices amount field and divides it by three.
if the amount field is less than £100 it leaves a string "not applicable"

can you help me with the expression
Question by:topUKlawyer
  • 2
  • 2

Author Comment

ID: 36935874
that is to say, if the invoice amount is less than £100 no one third calculation is made and the text is entered.
LVL 19

Accepted Solution

MINDSUPERB earned 1000 total points
ID: 36935914
Try to use this:

calc1: IIf([invoiceAmount]<100,"Not Applicable",[invoiceAmount]/3)

LVL 19

Assisted Solution

by:Richard Daneke
Richard Daneke earned 1000 total points
ID: 36935943
Database updated. trial.accdb

Author Comment

ID: 36935976
Thanks guys for the quick and helpful repsonse.

I notice both of you have put what looks like two letter I's as part of the If bstatement.

Is this intentiional and if so what does it do/signify?

or is it my eyesight seeing things!
LVL 19

Expert Comment

by:Richard Daneke
ID: 36936921
Iif means imediate if. Just the syntax that is used.!!!!!!

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

872 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