HardCode calculated field in a query

[Guest]

I have a query which has a calculated field which is date difference of start
date and end date. No when i run the query the calculated field shows either
0, >0 or <0 values in the field. What i want is to somehow hardcode the
displayed values instead of 0, >0 or <0. Like if it is 0 or >0 i want to
display "yes" and if it is <0 i want to display "No". How can i do this.

 

[Douglas J Steele]

IIf([MyField] <= 0, "yes", "no")

 

[Gina Whipp]

You mean like.. YesNo: IIf([NameOfCalculatedField]<0, "No", "Yes")

 

[Guest]

But where do i write this code in the query?

IIf([MyField] <= 0, "yes", "no")

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have a query which has a calculated field which is date difference of start
date and end date. No when i run the query the calculated field shows either
0, >0 or <0 values in the field. What i want is to somehow hardcode the
displayed values instead of 0, >0 or <0. Like if it is 0 or >0 i want to
display "yes" and if it is <0 i want to display "No". How can i do this.

 

[Guest]

where do i write this code in the query?

You mean like.. YesNo: IIf([NameOfCalculatedField]<0, "No", "Yes")

I have a query which has a calculated field which is date difference of
start
date and end date. No when i run the query the calculated field shows
either
0, >0 or <0 values in the field. What i want is to somehow hardcode the
displayed values instead of 0, >0 or <0. Like if it is 0 or >0 i want to
display "yes" and if it is <0 i want to display "No". How can i do this.

 

[Gina Whipp]

Open your query, go to the end and copy and paste the below on the Field:
line, then replace 'NameOfCalculatedField' with the name of the field. View
the query if all is well, close and save. If not, write back.

where do i write this code in the query?

You mean like.. YesNo: IIf([NameOfCalculatedField]<0, "No", "Yes")

I have a query which has a calculated field which is date difference of
start
date and end date. No when i run the query the calculated field shows
either
0, >0 or <0 values in the field. What i want is to somehow hardcode the
displayed values instead of 0, >0 or <0. Like if it is 0 or >0 i want
to
display "yes" and if it is <0 i want to display "No". How can i do
this.

 

[Guest]

Thanks Gina

Open your query, go to the end and copy and paste the below on the Field:
line, then replace 'NameOfCalculatedField' with the name of the field. View
the query if all is well, close and save. If not, write back.

where do i write this code in the query?

You mean like.. YesNo: IIf([NameOfCalculatedField]<0, "No", "Yes")

I have a query which has a calculated field which is date difference of
start
date and end date. No when i run the query the calculated field shows
either
0, >0 or <0 values in the field. What i want is to somehow hardcode the
displayed values instead of 0, >0 or <0. Like if it is 0 or >0 i want
to
display "yes" and if it is <0 i want to display "No". How can i do
this.