Afternoon all,
I'm trying to find out what the Access equivalent is of the Excel "IF(And(" formula. To elaborate on my question; I have a number of mailbox's in my database (you may of seen my other post about incremental's) and I need to split them out... As an example I will need to find Mailbox's between 1GB and 2GB. I've now split the full name of the text into just a number (e.g. 1, 1.456, 1.764) so I know need a formula to return what I want... In Excel I would do this...
Code:
IF(And([columnname]>1,[columnname]<2),"True","False")
is there a equivalent in Access? The only thing even remotely close is the AND function outside of an IIF (below) which isn't what I want as i'll have to create multiple queries.
Code:
SELECT * FROM Persons
WHERE FirstName='Tove'
AND LastName='Svendson'