I'm trying  to create a program in ZC that allows us to track some payroll

information and margins on a per cleaning bases (own a cleaning company

with several hundred clients).   Here's what I need and I've attached the beginnings

of my form/view as well:

We work in crews of 3-4 people.   Each crew supervisor brings back work orders

for all the homes they cleaned each day.  Usually between 4-6 homes per day.

I need my admin person to take each work order and input the following information on a daily basis:

1. Date of cleaning

2. Customer name

3. Hours it took to clean at each client's home

4. Each employee's name (each cleaner) that was at that particular clients home cleaning

5. Price charged customer for that day's cleaning

The information I need to analyze from this is the following:

1. Automatically total hours of each employee for the pay week

2. Automatically add the hours up for the work week times hourly rate for EACH employee

3. Automatically provide me with a Gross Profit (in dollars) and Gross Profit Margin (percent) for each client

    example customer:  joe smith

    Total Wages for Joe Smith Cleaning: $35

    Price we charged Joe Smith for that specific cleaning: $100

    Gross profit ($100 less $35 = $65 Gross profit.....    $65/100= 65% Profit Margin

Can anyone help me with this?  I've been working on this for DAYS and DAYS and can't figure out how to do this.

I've attached some of what I've done.  I have it set up where we check the employee name if they worked and it automatically fills in their hourly pay in the EMPLOYEE NAME WAGES field

Thank you very much for any help.