Calculated field quiries

[Buffy]

Hey,
I wondered if you could help with a calculation query problem I have. I would like to use a calculation query with an IF function. So that if a field which I have, which has a yes/no data type, is not checked the calculation takes into account the value that field has for that particular record. The calculation only requires the value to be added to another value.
Thanks.

 

[Russell Hauf]

This doesn't sound too hard - can you give an example of your data, and an example of what you'd like to see?

Thank you!

 

[Corticus]

I would like to use a calculation query with an IF function.

For "if" in Access, use IIF.

So that if a field which I have, which has a yes/no data type, is not checked the calculation takes into account the value that field has for that particular record.

Could you clarify, it sounds like you're saying you want to add the value from a True/False field depending on whether or not the field in T/F. Do you mean add the value -1 for true, and nothing for false. That's the only values you're going to get from a true/false field. If you're saying you want to add the value from field1, depending on whether or not field2 is T/F, that would make a little more sense. In the blank for a new field with your query in design view, add something like:<pre>Expr1: IIf([T/F]=-1,[Field1]+[Field2],[Field1])</pre>
This would add Field1 and Field2 if the T/F field had 'T' checked.

edit:
and only display [Field1] if 'F' is checked.

HTH,
Corticus
This message was edited by Corticus on 2002-12-18 10:44