Get Rid of Enter Parameter Values

[rpraveen6r]

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

[ranman256]

What is the param field its asking for?
if its an existing field the remove the [xxxx] bracketed field
if its NOT an existing fields then you have spelled a field wrong, or asked for a field that does not exist.

be sure to copy the fieldname (not type it) then paste it into the criteria.

[John_G]

Second Reply Due: [First Reply]+180

I think it's there - [First Reply] should probably be [First Reply Due]