[SOLVED]  Lookup Table Custom WHERE Expression

This topic is locked

[SOLVED] Lookup Table Custom WHERE Expression	10/27/2010 9:10:40 AM
ASPRunnerPro General questions
S sunnynayak author I have a Table employeeInformation of which i am using empID as a Link and Display Field for Lookup. I also have two more fields active and inTraining which are Yes/No Fields. I want to write an expression which will only show empID WHERE active=Yes and inTraining=Yes Tried `"active=Yes" & "inTraining=Yes"` but does not work for me. Thanks.


S	sunnynayak author 10/27/2010
	I have a Table employeeInformation of which i am using empID as a Link and Display Field for Lookup. I also have two more fields active and inTraining which are Yes/No Fields. I want to write an expression which will only show empID WHERE active=Yes and inTraining=Yes Tried `"active=Yes" & "inTraining=Yes"` but does not work for me. Thanks. Just realised i was using an incorrect operator. Fixed. `"active=Yes" and "inTraining=Yes"`