limit data in table by variable

[omyahamburg]

Dear all

I am struggling.

I have a table as follows:

To calculate the days overdue I use the expression today()-[Due Date].

Now I want use a variable, e.g. vDay=500 and I like to limit the data in the table

only to show me those rows, where today()-[Due Date] <= 500 is.

I appreciate your help.

Joerg

[omyahamburg]

Dear Itsangad

Seems perfect. I'll check in my final app if it works.

Thanks a lot.

Joerg

[#3]

Sure, no problem. I just missed to remove the sum(Amount) column and also the rename of labels.

Let me know if in any other way I can help.

Thanks,

itsangad

[omyahamburg]

Dear Itsangad

Don't worry, everything is fine so far. As I'm already at home without access to my server I'll check further with my app on Monday.

If I have problems I appreciate If I could count on further help from you.

enjoy your weekend.

Joerg