Search results

Okay!!!! :D Query 1 is a success!! Thank you. So for Query 2 to work I will need a table for the CAP info correct? That way it can compare? Please advise. Once again... thank you!

Thank you for the help. Will that look at ALL users and ALL activities and group as such? I would be happy to email dB with table. It is about 3mb in size if you would like to look at it.

Have about 15000 records in a table [activity] and in the table a person can have many instances of one activity; for example, Routine Fitness, Dental Exam, etc.. It is a one-to-many where the user can have many activities; however, the activities have a value, and that activity is capped at a...