![]() ![]() You can use the And function with the Or function in VBA, for example: If (LWebsite = "" Or LWebsite = "") And LCount >=1000 Then Otherwise, it would set the LResult variable to the string value "Low". ![]() This would set the LResult variable to the string value "High" if both LWebsite was "" and LCount > 250. Let's look at an example that combines the And function with the If Statement in VBA: If LWebsite = "" And LCount > 250 Then ![]() The And function with this syntax can only be used in VBA code in Microsoft Access. The And function can be used in the following versions of Microsoft Access: The And function returns FALSE if any of the conditions are FALSE. The And function returns TRUE if all conditions are TRUE. condition_n Expressions that you want to test that can either be TRUE or FALSE. The syntax for the And function in MS Access is: condition1 And condition2 ) Parameters or Arguments condition1, condition2. It returns FALSE if any of the conditions are FALSE. The Microsoft Access And function returns TRUE if all conditions are TRUE. This MSAccess tutorial explains how to use the Access And function with syntax and examples. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |