Hello Experts!
I am beginner level and any guidance will be a blessing!
Just cannot figure out what went wrong as initially the form was working. The Query is returning the correct Number the issue is displaying in the Form.
I have a footer Total value that comes from a query. I tried DSum and Dlookup and I am getting either the #ERROR or #Name?
Footer Formula in one textbox ControlSource =DLookUp("SumOfOrignalBudget","WPTableFormTotalQRY","[ProjectID]= " & [Forms]![WPProjectUpdateFRM]![NewProjectWPTableFRM]![ProjectID])
=DSum("OrignalBudget","WPTableFormTotalQRY","[ProjectID]= " & [Forms]![WPProjectUpdateFRM]![NewProjectWPTableFRM]![ProjectID])
Query
SELECT ProjectWPTable.ProjectID, ProjectWPTable.DocumentType, Sum(ProjectWPTable.OriginalBudget) AS SumOfOriginalBudget, Sum(ProjectWPTable.CurrentBudget) AS SumOfCurrentBudget, Sum(ProjectWPTable.CurrentExpenditure) AS SumOfCurrentExpenditure, Sum(ProjectWPTable.BudgetedHours) AS SumOfBudgetedHours, Sum(ProjectWPTable.ActualHours) AS SumOfActualHours, Sum([CurrentBudget]-[CurrentExpenditure]) AS WPBudgetRemaining, Sum([BudgetedHours]-[ActualHours]) AS SumRemainHours
FROM ProjectWPTable
GROUP BY ProjectWPTable.ProjectID, ProjectWPTable.DocumentType
HAVING (((ProjectWPTable.ProjectID)=[Forms]![WPProjectUpdateFRM]![NewProjectWPTableFRM]![ProjectID]));
Thanks
Taruna
I am beginner level and any guidance will be a blessing!
Just cannot figure out what went wrong as initially the form was working. The Query is returning the correct Number the issue is displaying in the Form.
I have a footer Total value that comes from a query. I tried DSum and Dlookup and I am getting either the #ERROR or #Name?
Footer Formula in one textbox ControlSource =DLookUp("SumOfOrignalBudget","WPTableFormTotalQRY","[ProjectID]= " & [Forms]![WPProjectUpdateFRM]![NewProjectWPTableFRM]![ProjectID])
=DSum("OrignalBudget","WPTableFormTotalQRY","[ProjectID]= " & [Forms]![WPProjectUpdateFRM]![NewProjectWPTableFRM]![ProjectID])
Query
SELECT ProjectWPTable.ProjectID, ProjectWPTable.DocumentType, Sum(ProjectWPTable.OriginalBudget) AS SumOfOriginalBudget, Sum(ProjectWPTable.CurrentBudget) AS SumOfCurrentBudget, Sum(ProjectWPTable.CurrentExpenditure) AS SumOfCurrentExpenditure, Sum(ProjectWPTable.BudgetedHours) AS SumOfBudgetedHours, Sum(ProjectWPTable.ActualHours) AS SumOfActualHours, Sum([CurrentBudget]-[CurrentExpenditure]) AS WPBudgetRemaining, Sum([BudgetedHours]-[ActualHours]) AS SumRemainHours
FROM ProjectWPTable
GROUP BY ProjectWPTable.ProjectID, ProjectWPTable.DocumentType
HAVING (((ProjectWPTable.ProjectID)=[Forms]![WPProjectUpdateFRM]![NewProjectWPTableFRM]![ProjectID]));
Thanks
Taruna