| | |
|
|
|
can i use an if then statement? |
|---|
| message from anonymous on 8 May 2004 |
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 replied to anonymous on 10 May 2004 |
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)
<anonymous@discussions.microsoft.com> wrote in message
news:a4c301c4353b$4b5ee7b0$a101280a@phx.gbl...
|
|
Archived message: can i use an if then statement? (Microsoft Access Error Message)
