Date Greater than

[phillbaker]

I have a query with two fields in

A: Date Payment Made
B: Date Payment Due

I want it to filter out and show if someone has an over due payment and also by how many days.

i have tried [Payments]![Payment Date Due]>[Payment Date Made] and also in the Payment Date Made column tried putting in >Payment Date Due] but some of them are showing up wrong so i think its something with what im putting in.

can you help

 

[Brianwarnock]

A criteria of > [Payment Date Due] in the [Payment Date Made] column should find those paid late but wont you also need to put Is Null in that col and < Date() in [Payment Date Due] col on a separate criteria row, for those not paid yet but should have been?

Brian