Hi everyone and thanks in advance for any help you are able to offer
I have a very simple database with just 2 tables.
Table 1 - ClientsTABLE which includes Client details and the respective "Day Rate" field and and a separate "Hourly Rate" field
Table 2 - TimesheetTABLE which I record separate Daily tasks for each client from the ClientsTABLE.
I have a "Unit" Field in TimesheetTABLE that has 2 options - either "Hrs" or "Day" to set the charge out to either number of hours or day rates for every day for each client I've worked for.
My question is:-
Is there a way I can set up a report that I run off at the end of each month.
I want to include a single report field that will change its value to show either the Client Table "Day rate" field or "Hourly Rate" field depending upon what "Unit" has been set on the timesheetTABLE Unit field.
Hope this makes sense?