compare 2 fields in report

[Vicki]

I am stuck. I need to compare two fields in a report and
if field2 is higher than field1 show a star next field2.

Thanks for any assitance.

 

[Duane Hookom]

Add a text box with a control source of:
=IIf(Field2>Field1,"*","")

 

[Vicki]

Thank you!
Can I do the same comparison in a Data Acess Page?

 

[Duane Hookom]

I don't use DAPs. You should be able to create this as a field in your
query.