Equivalent of Excel AND() function?

G

Guest

Is there an equivalent of Excel's AND() function in Access? I have looked
for threads related to "multiple conditions" but they all seem to be about
multiple conditions yielding the same result. I would like have my formula
yield a certain result only when two or more conditions are true. Right now
my formula is:

NewVendor:IIf([Category]="Leave","SL0001-1")

But I only want to assign the NewVendor SL0001-1 if the record also meets
the condition [AGoal]=True. Can I do this? I have looked in help and here
in the newsgroups and I'm not seeing it. Seems like if Excel can do it,
Access MUST be able to.

Thanks very much for your help.
 
G

Guest

When you use IIf(), you should provide 3 arguments like:

NewVendor:IIf([Category]="Leave" AND [AGoal]=True ,"SL0001-1", Null)
 
F

fredg

Is there an equivalent of Excel's AND() function in Access? I have looked
for threads related to "multiple conditions" but they all seem to be about
multiple conditions yielding the same result. I would like have my formula
yield a certain result only when two or more conditions are true. Right now
my formula is:

NewVendor:IIf([Category]="Leave","SL0001-1")

But I only want to assign the NewVendor SL0001-1 if the record also meets
the condition [AGoal]=True. Can I do this? I have looked in help and here
in the newsgroups and I'm not seeing it. Seems like if Excel can do it,
Access MUST be able to.

Thanks very much for your help.
Click to expand...

NewVendor:IIf([Category]="Leave" AND [AGoal] = True,"SL0001-1","")
 
G

Guest

Thank you Duane & fredg!

For future reference, is there a limit to the number of AND statements I can
embed within the IIf() statement?
--
Ann Scharpf


Duane Hookom said:
When you use IIf(), you should provide 3 arguments like:

NewVendor:IIf([Category]="Leave" AND [AGoal]=True ,"SL0001-1", Null)

--
Duane Hookom
Microsoft Access MVP


Ann Scharpf said:
Is there an equivalent of Excel's AND() function in Access? I have looked
for threads related to "multiple conditions" but they all seem to be about
multiple conditions yielding the same result. I would like have my formula
yield a certain result only when two or more conditions are true. Right now
my formula is:

NewVendor:IIf([Category]="Leave","SL0001-1")

But I only want to assign the NewVendor SL0001-1 if the record also meets
the condition [AGoal]=True. Can I do this? I have looked in help and here
in the newsgroups and I'm not seeing it. Seems like if Excel can do it,
Access MUST be able to.

Thanks very much for your help.
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search function in Excel 5
Access equivalent of Excel's Product() 2
function that equivalent to vlookup in Excel 1
IF function w/ 'and' condition 2
Equivalent of Mod function in Access 3
Excel Excel help - sumif function two conditions 2
Should multiple trues in a Switch function yield #Error? 5
Access equivalent to Excel's VLookup function 10

Top