Appending

[Jeff4505]

Hi,

I need to create a query that looks at the "last active" date on a member's table and to then change the "status" field to "inactive" if it is greater than 2 years ago.

Thanks

 

[Brianwarnock]

I think you mean updating.
You will need an update query like


UPDATE Table1 SET Table1.status = "inactive"
WHERE ([datefield]<(DateAdd("yyyy",-2,Date())));

Brian

 

[Jeff4505]

Thanks, that worked great.