DSum

[Guest]

Hello.
I have a subform located on the footer of a Form.
I need to Sum everything in the subform "HrCost" field.

These are the form names:
Main form name: frm_ProjectDetails
Subform name: frm_ProjectDetailsSubform


I created a text box with the following Control Source.
=DSum("[HrCost]","tbl_MainDateServiceInfoSub","[Category]=[frm_ProjectDetails].[Form]![ProjectOrCategoryName]")


I get the #error on that field when I am in form view.
Is there an easier way of doing this or can you help me fix the code.

Thanks.
Your help is greatly appreciated.

Iram/mcp

 

[Douglas J. Steele]

It's not clear to me whether ProjectOrCategoryName is on the main form (i.e.
frm_ProjectDetails) or on the subform (frm_ProjectDetailsSubform).

If ProjectOrCategoryName is on frm_ProjectDetail, try

=DSum("[HrCost]","tbl_MainDateServiceInfoSub","[Category]=[Forms]![frm_ProjectDetails]![ProjectOrCategoryName]")

If it's on frm_ProjectDetailsSubform, try:

=DSum("[HrCost]","tbl_MainDateServiceInfoSub","[Category]=[Forms]![frm_ProjectDetails]![frm_ProjectDetailsSubform].Form![ProjectOrCategoryName]")

Actually, you'll need to check the name of the subform control on
frm_ProjectDetails: depending on how you added frm_ProjectDetailsSubform as
a subform on frm_ProjectDetails, the name of the subform control may
something other than frm_ProjectDetailsSubform. If it is different, you need
to use the name of the subform control.

 

[Guest]

Hello Douglas.
My friend walked by right after I sent the post and we got it resolved.

Thanks!
You are the man anyways!

Iram/mcp

It's not clear to me whether ProjectOrCategoryName is on the main form (i.e.
frm_ProjectDetails) or on the subform (frm_ProjectDetailsSubform).

If ProjectOrCategoryName is on frm_ProjectDetail, try

=DSum("[HrCost]","tbl_MainDateServiceInfoSub","[Category]=[Forms]![frm_ProjectDetails]![ProjectOrCategoryName]")

If it's on frm_ProjectDetailsSubform, try:

=DSum("[HrCost]","tbl_MainDateServiceInfoSub","[Category]=[Forms]![frm_ProjectDetails]![frm_ProjectDetailsSubform].Form![ProjectOrCategoryName]")

Actually, you'll need to check the name of the subform control on
frm_ProjectDetails: depending on how you added frm_ProjectDetailsSubform as
a subform on frm_ProjectDetails, the name of the subform control may
something other than frm_ProjectDetailsSubform. If it is different, you need
to use the name of the subform control.


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hello.
I have a subform located on the footer of a Form.
I need to Sum everything in the subform "HrCost" field.

These are the form names:
Main form name: frm_ProjectDetails
Subform name: frm_ProjectDetailsSubform


I created a text box with the following Control Source.
=DSum("[HrCost]","tbl_MainDateServiceInfoSub","[Category]=[frm_ProjectDetails].[Form]![ProjectOrCategoryName]")


I get the #error on that field when I am in form view.
Is there an easier way of doing this or can you help me fix the code.

Thanks.
Your help is greatly appreciated.

Iram/mcp