Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #10  
Old 11-20-2012, 11:46 AM
56_kruiser 56_kruiser is offline AND function be used as criteria in DB functions? Windows 7 64bit AND function be used as criteria in DB functions? Office 2010 64bit
Novice
AND function be used as criteria in DB functions?
 
Join Date: Nov 2012
Posts: 26
56_kruiser is on a distinguished road
Default

Quote:
Originally Posted by Colin Legg View Post
No, the criteria in your formula is applied to each row in the database. So you can use it to apply criteria across a row in the database which would be difficult or impossible to do by laying out the criteria how I mentioned earlier.

I've attached an example. In it I want to get a sum but only where the name begins with a capital "C". The criteria I'm using is:

=EXACT(LEFT(B3,1),"C")

So the LEFT() function gets the first letter and EXACT() returns TRUE or FALSE depending on if the first letter is a capital "C".

Does that make sense?

Hi, yes, that all makes sense, and I follow.

I think where the confusion is, is that I was interpreting the statement of returning True or False literally, ie, useing the value True as THE criteria. Not the answer to the criteria.

I'm in synch.

I appreciate your input.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Acos, Cos and Sin functions in DAX PowerPivot eramzan Excel 0 03-01-2012 11:32 AM
Using IF and Vlookup functions cpladson Excel 3 12-14-2011 11:57 PM
AND function be used as criteria in DB functions? Assign functions to F1, etc. ibclare Office 4 06-02-2011 03:22 PM
AND function be used as criteria in DB functions? ** Using Functions djreyrey Excel Programming 10 02-08-2011 04:18 PM
Automated Functions?? nickypatterson Outlook 0 08-27-2009 01:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:15 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft