i am trying to make a coloumn in a query to add up the total amount of fees per doctor per day and finally a total amount per week how would i go about doing this i have looked at the microsoft help files but they arent giving me any relevant information to be dealing with.

help needed