Trouble with query calculation

[QueryFury]

I am trying to combine a query of employees that will automatically give me a amount earned on various jobs and pay grades.

The columns I'm working with are "start date" "end date" and "hourly wage"

Basically the jist of what I'm trying to do is:

Salary: (end date - start date) * (5/7) * 8 * hourly

The 5/7ths is because everything is done in the time frame of weeks, but employees can only work 5 days in a week regardless of days.

Any help would be greatly appreciated.

[alansidman]

What happens when you use your formula as an expression in your query? Does it work? Does it kick out errorneous information? Do you have an issue?

[QueryFury]

Potential Salary:[end date]-[start date]*(5/7)*8*[hourly wage]

[QueryFury]

This is a screenshot of what I have going on so far.

[hertfordkc]

The screenshot doesn't show the hourly rate.
Also, maybe the enddate has to be shown as a query field before it can be used in a calculated field.

[RayMilhon]

End date does not have to be shown as a query field to use it in a calculated field. But I personally would use the following Formula
Salaryatediff("d",[start date],[end date])*(5/7)*8*hourly

there is 1 issue with that formula however If [end date] is null. based on your original post I am presuming that the project is completed prior to payment.

[RayMilhon]

Just noticed everytime I put in a colon d :d I get that stupid happy face.