Help Needed: Generate Client Scores from Appointment Data

I've got a table of client appointment information, and I want to generate a client score for each client in a separate table with a unique deduped client list. No matter how many times i try, its struggling to pull in data from thousands of rows of appointment data and create a score in a new table. Anybody have a quick fix?