to search and autosum for the field

[Paksiw000]

Hi All,
good day.

I need everyone's help.

I'm new to this forum and new to ms access, currently I'm trying to improve the standard calculation of my work to be quick. It was used as excel file and done manually. and it resulted too many mistakes.


I use dlookup function but not able to get what I want.

I want the kVATotal field to automatically sum all the connected loads in every cableID.

example:
P1-JB01 = sum of LF01 ~ LAST
P1-SW1 = sum of LF02 + LF03
P1-LF04 = LF04


CableID From To kVA kVATotal
P1-JB01 LDB-01 JB01 - 1620
P1-JB02 JB01 JB02 - 540
P1-LF01 JB02 LF01 90 360
P1-JB03 LF01 JB03 - 270
P1-SW1 JB03 SW1 - 180
P1-LF02 SW1 LF02 90 90
P1-LF03 LF02 LF03 90 90
P1-SW2 JB03 SW2 - 90
P1-LF04 SW2 LF04 90 90
----more like this to be added


Hope could help me.


Paksiw000

 

[Micron]

If the field is in a query or form/report textbox, you want the DSum function
DSum (expression, domain, [criteria] ), not DLookup.

DSum("kvaTotal","YourTableName") if you don't need criteria.
If the field you refer to is in the table, storing aggregate values in a table is not good practice.

 

[Paksiw000]

hi micron,

sorry for this late reply.
I put it in the field table. i'll take your advice i'll put it in the query or report.

I will try this Dsum function and feedback if its ok.

Thank you for the great help.