Comparing Query & Date()

[tofler]

I have use a =DateAdd("y",+[dueDay],[routedDate]) function to displa
the due date on the report.

However, on the report itself...i want to derive the remaining day
left starting from todae to the due date... how do i do it?

comparing the query & todae date?

Pls advise
Thank yo

 

[Michel Walsh]

Hi,


In a report, you can loop through a standard loop (For i = 1 to n)
and play with the Boolean run-time properties MoveLayout, NextRecord (and
PrintSection).

In a query, you would have to use a driver table (with integers from
1 to M and a WHERE clause implying that this integer should be <= n ) with
that field added to the starting date field.



Hoping it may help,
Vanderghast, Access MVP