Summing from a Subform Table

[SpartanAOD]

I have a form that shows records of employees (name: Employee Records). In a tab control, I have a page that contains a table style subform (name: Infractions) with record of infractions, such as no call / no show and tardy. Three relevant columns in that subform are: Infraction Date, Major Points, and Minor Points. On that same tabbed page, I would also like text box that sums the Major Points column if the Infraction Date has been less than 365 days, and sum the Minor Points column if the infraction date has been less than 90 days.

I have tried searching for similar questions, but have come up short.

 

[alansidman]

try changing the record source for the infractions tab to a query that does what you want instead of the table directly.

 

[SpartanAOD]

try changing the record source for the infractions tab to a query that does what you want instead of the table directly.

I wish I could embed a screenshot. My intentions are to let them add and view all infraction records for that employee, but have the textbox display how many points are active. Actually, there will also be a second textbox that had a count of active infractions, as well.

 

[alansidman]

Look at the DSum function. Here is a short tutorial https://www.techonthenet.com/access/functions/domain/dsum.php

 

[SpartanAOD]

Look at the DSum function. Here is a short tutorial https://www.techonthenet.com/access/functions/domain/dsum.php

I tried using the expression builder to make this, only summing up Major Points for now

=DSum([Infractions]![Major Points],[Infractions],DateDiff("d",[Date of Hire],Date())<365)

I get a #Name? error

=DSum("Major Points","Infractions",DateDiff("d","Date of Hire",Date())<365)

Yielded a #Type!