Solved VBA Function and SQL

[Teri Bridges]

I am back. Just when I think I a figuring something out....Nope not a clue!

I have a temp query I created to get my SQL statement. I want to total the lesson duration for each course to determine my course Hours.

The sum of lessons (lesson total) is related to the catalog ID. Currently using the code that I have written, it appears to be counting the # of rows not giving me the sum of lessons. Any help is appreciated.

 

[GaP42]

If you place a text control in the foot of the subreport: LessonsList_Srpt such that datasource = sum(lessonDuration). Give it a name. The footer can remain hidden.
Back at the top of the main form change the data source for deliveryhours to be the name you assigned to the new text control in the footer in the form of:
for eg: =([LessonsList_Srpt]![TotalLessonDuration])

Result for me shows 4.

 

[Teri Bridges]

I am back. Just when I think I a figuring something out....Nope not a clue!

I have a temp query I created to get my SQL statement. I want to total the lesson duration for each course to determine my course Hours.

The sum of lessons (lesson total) is related to the catalog ID. Currently using the code that I have written, it appears to be counting the # of rows not giving me the sum of lessons. Any help is appreciated.
View attachment 110897

If you place a text control in the foot of the subreport: LessonsList_Srpt such that datasource = sum(lessonDuration). Give it a name. The footer can remain hidden.
Back at the top of the main form change the data source for deliveryhours to be the name you assigned to the new text control in the footer in the form of:
for eg: =([LessonsList_Srpt]![TotalLessonDuration])

Result for me shows 4.

Execllent! Thanks