Calculation problem (1 Viewer)

[andyh]

Hi everyone, Thanks for reading/ any help...

I have a form with 7 field for names and 7 fields for points.

Users enter their name and later, points are allocated to the relevant points fields.

I am trying to get a summary report to show all the points for an individual user. The problem is that the user's name could be in any one of the seven fields on any record.

How can I do this?

 

[Chris RR]

How is the table defined? It doesn't really matter so much how it is displayed on the form, it's the table setup that is important.