Update Query

[James Pye]

Hi,

I have a fantasy football database, and I identify new weekly points by New:Sum([Current_Pts]-[Previous_Pts]) from table Teams, in a query.

And then 'manager of the week' by =IIf([New]=DMax("New","qry_SummaryPts"),"***","") on a summary report.

Also, on this report I have a column that is the number of times a person has been 'manager of the week': I currently do this manually by opening the report to see who is motw and then update that field in the Managers table then, reopen the report to export it.

Can this be done via an update query? Or is VBA better?

Thanks
James

 

[G81]

It may be better to have a motw table like:

Week - ManagerID
1 -------52
2 -------21
3 -------20
4 -------21
5 -------3


which you would append to every week

then you can do a count of each managerid within that table for your report. Might be a little better doing it this way, rather than updating a total count and you have a full record of who won motw every week.

 

[James Pye]

That has worked a treat thanks G81.