Search results

I have a from called invoice in which i give the From_Fiscal_Year which is a number and To_Fiscal_Year and the Project_# of that project for which iam trying to generate the invoice. In this I have a Print Report button when i am trying to print the report i am not able to take the information...

Hi Guys, Iam doing an Access project And i have poblem in calculation in a form. This calculation basically is between a form and a table. I have a form called "Yearly _Amount" in which there is a field called "Total_Hours". Now i want to calculate this Total_Hours as "Sum of Hours" (Hours is...

It says "the expression you entered has invalid syntax"

This is the code. When iam not writing the criteria it is working properly. But when i write the criteria part Its giving error, shows "#Name?" in the particular field. =DSum("[Hours]","[Time_Sheets]",[Employee_#]=Time_Sheets![Employee_#] And [Fiscal_Year]=Time_Sheets!Fiscal_Year And...

Form design->properties -> control Source =DSum("[Hours]","[Time_Sheets]"," [Employee_#]"="Time_Sheets![Employee_#]") i have built this expression in the control source. but ti is not working.

Tried it I tried that too. It is not helping me. Iam poor in queeries though. My entire project deals with the same thing. I mean summing the totals by checking the crteria. Hopefully i find an answer soon.

Not working When Iam using this DSum() its just obtaining the total of hours but not cheking the criteria. I have been trying it for past two days using DSum() function.Its not checking the criterua for the three fields to be equal.Iam using expression builder to build this expression.

Hi Guys, Iam doing an Access project And i have poblem in calculation in a form. This calculation basically is between a form and a table. I have form called "Yearly _Amount" in which there is a field called "Total_Hours". Now i want to calculate this Total_Hours as Sum of hours (Hours is...

Hi Guys, Iam doing an Access project And i have poblem in calculation in a form. This calculation basically is between a form and a table. I have form called "Yearly _Amount" in which there is a field called "Total_Hours". Now i want to calculate this Total_Hours as Sum of hours (Hours is...