Recent content by Mark1982

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.