can i use an if then statement?

[Guest]

i want to do a calculation that works out a percentage
discount but the customer will only get the discount if
he/she buys X amount of goods, i know i could do this
with an if then else endif statement but i dont know if i
could do it in access, please help

 

[david epsom dot com dot au]

Yes in vba, you can use
if xxxx then yyyyy
or
if xxxx then
yyyy
else
zzzz
end if
or any of several different forms.

You can also use the VBA function IIF

IIF(xxxx,yyyy,zzzz)

This is especially convenient when used inside a query.

(david)