R
Rag742
How do I create a Query using two tables that have dates field to
calculate a value using both the tables for a Date Range. For Example
I have four TABLES- Time Card(TC), PROJECT, TC hours(HOURS), and TC
expenses(EXPENSE). TC contains name of employees and their billing
rates. PROJECT contains Name of Project. HOURS field are TCId,
PROJECTId, Dateworked, and Hours. EXPENSE contains fields TCId,
PROJECTId, Dateexpense, Expense.
I want to build a query that over a Date Range that sums billable
amount=hours worked* billing rate+ expense.
I set the Dateworked >=[forms]![Report Date Range]![BeginDate] And
<=[forms]![Report Date Range]![EndDate]
What do I do with the Dateexpense to set the Date Range.
Some one suggested inner join. But this creates another problem. If
there is no value for a
date in expense or hour field for the dates in Range the formula of
total bill is blank. How do i get around this
calculate a value using both the tables for a Date Range. For Example
I have four TABLES- Time Card(TC), PROJECT, TC hours(HOURS), and TC
expenses(EXPENSE). TC contains name of employees and their billing
rates. PROJECT contains Name of Project. HOURS field are TCId,
PROJECTId, Dateworked, and Hours. EXPENSE contains fields TCId,
PROJECTId, Dateexpense, Expense.
I want to build a query that over a Date Range that sums billable
amount=hours worked* billing rate+ expense.
I set the Dateworked >=[forms]![Report Date Range]![BeginDate] And
<=[forms]![Report Date Range]![EndDate]
What do I do with the Dateexpense to set the Date Range.
Some one suggested inner join. But this creates another problem. If
there is no value for a
date in expense or hour field for the dates in Range the formula of
total bill is blank. How do i get around this