Calculated Query

[bgcogen]

Hi.
Basically I wan tto know is it possibe to create a calculated field in a query that is based on data from 2 other fields in the same query but is only displayed when a text field in the same query contains a certain string of text.

E.g.

Field1: Field2/Field3 [But onle display when Field4 = "Europe"]

Can this be done???

Thanks,
Declan

 

[Ally]

There are 2 ways that I can thing of, of doing this. Someone else may come up with another way.

One is display the result of your calculated field on your form and if the result of eg Field 4 = Europe, make field visible, invisible if not.

The other way would probably be an IIf statement within the query in Field 1:

IIf([Field4]="Europe",[Field2]/[Field3],"")

Without playing around with it myself, the syntax may be slightly wrong, but it's along those lines.