If..Then with multiple criteria 1

You might want to download the Macro reference guide from srs and look at the If...Else possibilities.


David L. Black Consulting

If you're doing a macro, you would write it like:

If Field$("A") = "X" and Field$("B") = "Y" Then
D = "Z"
Else
If Field$("A") = "X" and Field$("B") = "Z" Then
D = "Q"
Else
D = "No value"
End if
DerivedField(D)

I find it easier to either do a decode or case statement using a derived field. Macros tend to slow down you querie and macros are alway after the fact. Not to mention, if you're using numbers with this querie you would have to seperately write a SUM field to calculate SUMS or COUNTS - and you can't even group or sort on macros.