Criteria to average 3values if another 3are the same

[popeye]

i have three fields called rates. Each rate value has a corresponding currency value.

I have an averge rate box in a querry with all the rates and their corresponding cureeency/

how can i get the query to average the rates only if they all have the same currency denomination.

Please help.

i tried setting the criteria under to average rate field to say iff currency1=currency2=currency3 but it didnt work

HElp??

 

[RichO]

To check if all 3 currencies are the same...

If Currency1 = Currency2 And Currency2 = Currency3...

 

[popeye]

hey thank you. i didnt even think of that. Kinda silly though its like physiscs.
If body A and body B are in thermal equilibrium and body B and body C are in thermal equilibrium then body A and body C can automatically be assumed to be in thermal equilibrium.

 

[popeye]

One More Criteria

i want it to return a string "Different Currency" if all three currencies arent the same.

can this be done?

Sorry, i meant to ask HOW can this be done?

 

[RichO]

IIf(Currency1 = Currency2 And Currency2 = Currency3, "Same Currency", "Different Currency")

You can replace "Same Currency" with whatever you want to show if all 3 are the same...