I have this expression in a form and it works perfect
DateAdd("d",63-Weekday(FirstContact,7),FirstContact)
But, where should I write it in a query? The query should show all the items
that shoul be removed from the list on the calculated date, and update the
"removed from the list" the field from there.
Thanks
Ioia

Add the expression as a calculated field in the query

Field: Removal: DateAdd("d",63-Weekday(FirstContact,7),FirstContact)
Criteria: = #2009-11-27#
Then you can apply criteria against the calculated field.

Another option would be to determine the date range of FirstContact that you
are interested in and apply criteria against firstcontact. That would
probably be something like the following if you were trying to get the records
with a removal date of 27 November. You might have to adjust the -62 and -56
by -7 to get the correct records returned.

Field: FirstContact
Criteria: Between DateAdd("d",-62,#2009-11-27#) and DateAdd("d",-56,#2009-11-27#)

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Ioia wrote:
> I have this expression in a form and it works perfect
> DateAdd("d",63-Weekday(FirstContact,7),FirstContact)
> But, where should I write it in a query? The query should show all the items
> that shoul be removed from the list on the calculated date, and update the
> "removed from the list" the field from there.
> Thanks
> Ioia
>
>

Thanks again! Both options worked perfectly
You are a genius
Ioia

"John Spencer" wrote:

> Add the expression as a calculated field in the query
>
> Field: Removal: DateAdd("d",63-Weekday(FirstContact,7),FirstContact)
> Criteria: = #2009-11-27#
> Then you can apply criteria against the calculated field.
>
> Another option would be to determine the date range of FirstContact that you
> are interested in and apply criteria against firstcontact. That would
> probably be something like the following if you were trying to get the records
> with a removal date of 27 November. You might have to adjust the -62 and -56
> by -7 to get the correct records returned.
>
> Field: FirstContact
> Criteria: Between DateAdd("d",-62,#2009-11-27#) and DateAdd("d",-56,#2009-11-27#)
>
> John Spencer
> Access MVP 2002-2005, 2007-2009
> The Hilltop Institute
> University of Maryland Baltimore County
>
> Ioia wrote:
> > I have this expression in a form and it works perfect
> > DateAdd("d",63-Weekday(FirstContact,7),FirstContact)
> > But, where should I write it in a query? The query should show all the items
> > that shoul be removed from the list on the calculated date, and update the
> > "removed from the list" the field from there.
> > Thanks
> > Ioia
> >
> >
> .
>