Afternoon all,
I am building a database and cant figure out how to display the average number of visits a consultant is making each month as a single text box on a form (total number of visits / total number of months).
I have a visit log table:
a Client Details table:
Client_ID
Client_Ref_No
Client_Name
Consultant
etc.
and a consultant table:
I am very comfortable using excel, but I am a complete novice as you can probably tell when it comes to access!
Any idea's database gurus?
I also have another table which details expenses claimed by consultant and I am hoping to apply the same logic to display the average expenses claimed per month.
Cheers.
I am building a database and cant figure out how to display the average number of visits a consultant is making each month as a single text box on a form (total number of visits / total number of months).
I have a visit log table:
VisitLog_ID
Client_Ref_No
Date_of_Visit
Client_Ref_No
Date_of_Visit
a Client Details table:
Client_ID
Client_Ref_No
Client_Name
Consultant
etc.
and a consultant table:
Consultant_ID
Consultant_Name
Consultant_Name
I am very comfortable using excel, but I am a complete novice as you can probably tell when it comes to access!
Any idea's database gurus?
I also have another table which details expenses claimed by consultant and I am hoping to apply the same logic to display the average expenses claimed per month.
Cheers.
Last edited: