Contolling visibility of one field based on the value of another 1

[kav123]

I have a query, a select query which returns a recordset based on two input parameters. However, there is another condition that needs to be met. There is one field called 'PerformanceCriteria', which is Yes/No field. And based on the value of this field, another field'PerformanceAchieved', from the same table is displayed/not displayed on the ASP web page.

Is there a way, i can achieve this, in Access queries itself?? Can i control when a particular field should be returned in the recordset, based on the value of another field in the same table. This condition is in addition to two input parameters, which are used in the where clause of the query to select the records.

 

[Eupher]

Well, not directly, but you can create an expression that would do it:

PerfAchieved: IIf([Performance Criteria], [PerformanceAchieved], "")

Ken S.

 

[kav123]

i.e. If i write a query like Select tblSomeTable.* from where lPID=@lPId and lOptionId=@lOptionId;, where should i put the If condition?? Can you please elaborate on that??

 

[kav123]

I think, you are telling me to write this expression, in the design view, and always the field would be returned, and based on the value of what you get, i would control the display of that particular page in the ASP page??

 

[Eupher]

Yes, in the QBE grid, enter the expression in the "Field" field in a blank column. When you run the query this will generate a field called "PerfAchieved" which will return either the value of [Performance Achieved] or a null string, depending on the value of [Performance Criteria].

Ken S.

 

[kav123]

Thanks, that did work out well!!!