T
Tracey
I have a form with a field called "date member joined" which automatically
enters this date + 1 year into a field called "expiry date". I have set the
field "expiry date" to colour red if expired and green if date coming up to
expiry in next 2 months. What I want now is a report that only shows expired
and another report to show those coming up to expiry. I presume the best way
to do this is with a query first but can't see how. I have also tried by
setting up a report and copying the conditional format but for some reason
the field "expiry date won't show any data in this report
Tanks
Tracey
UK
enters this date + 1 year into a field called "expiry date". I have set the
field "expiry date" to colour red if expired and green if date coming up to
expiry in next 2 months. What I want now is a report that only shows expired
and another report to show those coming up to expiry. I presume the best way
to do this is with a query first but can't see how. I have also tried by
setting up a report and copying the conditional format but for some reason
the field "expiry date won't show any data in this report
Tanks
Tracey
UK