Issue with SUM on continuous form (1 Viewer)

MarRyb · Dec 2, 2015

Hi there,

I'm new in MS Access and I know the golden rule about searching for an answer prior creating a post, but I could not find anything helpful.

My problem is as follows.

I have 2 tables ComponentsT (with fields - ComponentID, comCode, comName and comPrice) and ComponentListT (with fields – ComListID, ComponentID and comlistQty), with two forms ComponentsF (Single Form) and ComponentsListF (Continuous Form).

My goal is to have list of components on that continuous form where I want to calculate comPrice*comlistQty in unbound textbox (txtTotalCompPrice) for each row. This works, I am using =[txtComponentPrice]*[comlistQty] (where txtComponentPrice is textbox taking its value from combobox – contro source is set to =[ComponentID].[column](3)).

However, when I try to calculate SUM in the cont. form footer for the textbox mentioned above I will get #Error. I am using this =Sum([txtTotalCompPrice]).

Attached is my DB file (MS Access 2013).

Thanks in advance for any help you can provide,
Martin

Ranman256 · Dec 3, 2015

dont sum the text box name, sum the field name.

sneuberg · Dec 3, 2015

Ranman256 said:
dont sum the text box name, sum the field name.

That's part of the problem I found that

=Sum([ComponentListT]![comlistQty])

works for the sum of the quantity, but for the other sum you will need to make the record source of the form a query which joins the two table so that you have a field there to use in the sum. Your sum will have to be the sum of the products something like:

=Sum([ComponentsT]![comPrice]*[ComponentListT]![comlistQty])

MarRyb · Dec 4, 2015

Thank you very much for this. It works now.

jebrahimpour@gmail.c · Dec 6, 2019

Hi,

Sorry if this is too late for this reply however some new users with the same question may find it useful, best is to use DSUM when you are in a form.

MarRyb said:
Hi there,

I'm new in MS Access and I know the golden rule about searching for an answer prior creating a post, but I could not find anything helpful.

My problem is as follows.

I have 2 tables ComponentsT (with fields - ComponentID, comCode, comName and comPrice) and ComponentListT (with fields – ComListID, ComponentID and comlistQty), with two forms ComponentsF (Single Form) and ComponentsListF (Continuous Form).

My goal is to have list of components on that continuous form where I want to calculate comPrice*comlistQty in unbound textbox (txtTotalCompPrice) for each row. This works, I am using =[txtComponentPrice]*[comlistQty] (where txtComponentPrice is textbox taking its value from combobox – contro source is set to =[ComponentID].[column](3)).

However, when I try to calculate SUM in the cont. form footer for the textbox mentioned above I will get #Error. I am using this =Sum([txtTotalCompPrice]).

Attached is my DB file (MS Access 2013).

Thanks in advance for any help you can provide,
Martin

Issue with SUM on continuous form (1 Viewer)

MarRyb

New member

Attachments

Ranman256

Well-known member

sneuberg

AWF VIP

MarRyb

New member

jebrahimpour@gmail.c

New member

Similar threads

Users who are viewing this thread