How to write an expression

[jlcwick]

I need to add a feild to a query that will compare 2 feilds and enter the word yes in the new feild.
So Feild a is greater than Feild B new feild should say yes. Can someone please help me, I have created a data base from scratch by looking at these threads and know i am stuck.

[gnawoncents]

In the Field row in your query, you can type something like what you see below.

YourFieldName: IIf([A]>[B],"Yes","")

[jlcwick]

Thank you so much!!