I have a table with the following info
Name | Dept | Month | HrsWorked | Cost
John BA Jan 09 20 500
John BA Feb 09 30 600
Sally DEV Mar 09 40 600
And i want to generate a report that will look like this
Dept | Jan 09...
I have 3 tables:
Projects:
ProjectCode
ProjName
Desc
StartDt
EndDt
Department:
DeptID
DeptName
Estimates:
EstID
fkDeptID
EstHours
DailyCost
EstBudget (basically EstHours * DailyCost)
now i want to create a form where i can add the estimated budget for a project by inserting est hours and...