Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Select value from table based on two criteria
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 07-21-2016, 08:10 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Select value from table based on two criteria Windows 7 64bit Select value from table based on two criteria Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

I suspect the comma does not coerce TRUE/FALSE to 1/0 where the * operator does
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #2  
Old 07-21-2016, 08:19 AM
gebobs gebobs is offline Select value from table based on two criteria Windows 7 64bit Select value from table based on two criteria Office 2010 64bit
Expert
Select value from table based on two criteria 		 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
Ahhhh...I'm forever switching between the two and never knew why any particular combination worked and another didn't.

Good karma for you, mate! Thanks!
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Select value from table based on two criteria Selecting random cells based on criteria mesTrethowan Excel 11 10-28-2015 06:51 AM
Select value from table based on two criteria Complex Mail Merge based on Criteria fairchance Mail Merge 11 08-22-2015 04:32 AM
transpose values based on mulitple criteria mlttkw Excel 1 12-06-2013 02:00 AM
MACRO - Insert row based on Form Field Criteria Elan05 Word VBA 5 04-16-2013 06:39 AM
Change values in cells based on criteria SaneMan Excel Programming 2 02-02-2012 07:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:38 PM.

Contact Us - Privacy Statement - Top

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