difficulty performing a query

[fabiobarreto10]

friends,

I'm having difficulty performing a query. I have a table with fields DATE_1 and Date_2. How do I know the records where the date DATE_1 is greater than Date_2.

Thank you.

[alansidman]

Create a new field and place this Expression in the field. Calc: IIF([Date_1]>[Date_2],"yes","no"). Then if you only want to see the records that are True/Yes, then put "Yes" in the criteria for this field.

[fabiobarreto10]

Perfect,

Thank you so very much.