Hello,
I have a query where I have calculated values. For an example, let's say I have 3 fields. One field is name, one field is a dollar amount, and the third (calculated) is second field * .05. Well, in the third field, I want to always multiply by the .05 unless the first field has a value of 'Mike', in which case I want to multiply by .025 instead of .05.
Any advice on this matter would be appreciated. TIA.
MAC