Determine what records show on report

[unnamedplayer]

Hello all,

I am trying to make a report based on a query but I need to do a little work with the results of the query to determine if they show up on the report.

For example, my query returns rows with fields such as Name, Type and Date. I need to look at the Date field and say for example it is Type A, add 1 year to the Date and determine if that date is in the future (date+1yr > now()). If so that record is not past due and therefore should not show up on the report. If a record is Type B, I need to add 5 years to the Date field and again determine if that calculated date is in the future and if it is, then again the record is not past due and should not show up on the report.

Basically I am trying to find the records that are past due and have them show up in a nice formatted report.

Any ideas how to do this?

Thanks so much!!!

 

[Rabbie]

The simplest way is to adjust your query so it only shows the records you want in your report. It should be quite simple to add a field to the query with a calculated due date in it and only show the records where DueDate < Date() . adjust as necessary