Updating table based on Max Values (1 Viewer)

[DFowler]

I am currently trying to update a table with the Max values from the below query.

select debtepisodes.accounts1,deepisodenum,Max(dehepisodenum) from debtepisodes,debtepisodeshistory
where debtepisodes.accounts1 = debtepisodeshistory.accounts1
group by debtepisodes.accounts1,deepisodenum
having deepisodenum <> max(dehepisodenum)

Can anyone suggest how this is possible as have tried for a day now with no success.

 

[neileg]

Why do you want to store the max? You can calculate it any time you want with your query.

 

[DFowler]

Why do you want to store the max? You can calculate it any time you want with your query.

I want to store the max value of the history table as this is what the customer sees. in essence this isn't a wholly access based question as it is mainly trying to find the sql coding required to update from history Max to other table