Im making a DB. I have a table with coloumn as follows
Report Despatch
First Reply (after 90 days of report despatch)
Second Reply (after 180 days of first reply)
Third Reply (after 180 days of first reply)
Im making a tracking query so that if anybody delays in reply.. I can send him remeber mail.
I made a query for this with
First Reply Due: [Report Despatch]+90
Second Reply Due: [First Reply]+180
so on..
in query in criteria i put <Date() for dates before system date.
When I use the same for Second Reply Due.. it pops up Enter Parameter Value. I want to get rid of this. Pls advice or any new method for this??
Thank You