Update Query problem

[SDLevy]

Hi,

I have a membership data base and I need to change the member's status from member to lapsed if they have not sent in their annual dues.

There are two tables - tblPeople and tblMembership - involved. Each person may have many membership records if they have been members for more than one year.

In tblPeople I have a field called MembersStatus. I want to update this based on the date of the membership in the tblMembership.

I am able to use DateAdd to calculate one year from the membership date but that doesn't work for anyone who has more than one record because the older record date is also being used.

I tried using a query within the query pointing to the Max date but I get an error message saying it needs to be an updateable query.

I hope I am missing something very simple.

Please advise,

Susan

 

[Jon K]

Max will render the Update Query non-updateable.


You can convert the query that uses Max into a Make-Table Query to create a temporary table. Then build the Update Query based on this temporary table.

Each time run the Make-Table query before running the Update Query.