Search results

Dear Sir Arnel I send you my updated database in your email.

Yes in previous there was no combo box but they told me to add. so i add it.

Dear Arnel, I try it not working. Please see the below: table name is: Budget 33101 Field in the Table: 1:Expense Code 2:Annual Budget 2018 3:Cost Control (which is combobox) have two fields 1.By Proponent 2.By Payrol) now i want to make dsum for each field of combo box to show me total of...

My Combo Box name is Cost Control and the combo box have two fields: 1.By Proponent 2.By Payroll i want to create a d sum for each one by annual budget 2018.

Dear Arnel, But my field is in Combo Box. and i want it dsum in my form.

I Cant Add add the query field to a form. i am doing it by control source. =([Query]![Annual Budget 2018]) its giving me error of (#Name?)

thank you so much i will follow your instruction.

no there is many but i just make one entry as a example.

Dear Arnel, Actually i want print per page by month. Kindly see the attached Pic.

how to create a report like monthly and yearly report?

Dear Arnel, I try this formula 0:-0;0 in propert format but its not giving me the result.

what is the formula? if my value is empty cell show me 0 or equal to 0. i am working in the form design. what is the formula and where to add the formula?

Dear CJ, I apply your Formula but still i got problem. Please see the attachment.

please see the attachment what i am getting error.

Dear Ranman256: PR33103 is the Table name. let me tell you i am applying the above formula in query.

here is My Formula: Total: DSum("[Invoice Amount]","[PR33103]","[PR ID]<=" & [PR ID]) Whats Wrong?

Dear Arnel, I am talking about Dsum in query: Totalsum("NumericFieldName", "TableName" [, Criteria]) I type it in Query of the total field. and its give me the result good. but when i go back to edit the same dsum function so i cant find it. i only see total abd the dsum formula its hide. but...

I Did the Dsum Formula and its working and the result is good. but when I want to see Query Table in Design View so i cant see the dsum formula in my total field. its hide the formula. why? why i cant see the Dsum Formula? how can i view it?

how to allow input Alphabet in numeric field ?

can you send me just a example?