Report - print calculated field off of form to a report

[Summer123]

Need help on reports, basically i have a form where i get info from multiple tables. On the main form itself i have 3 calculated fields for hours where i add all the hours i choose (from a subform) onto the main form.

my issue is i can create a query to come up with all the fields for my report, but how do i get the calculated fields on my main form on the report? any suggestions would be great... is there a way to print the calculated fields on the main form to a report? or do i have to do the same calculations on the report itself?

 

[rzw0wr]

Do the calculations in a query or redo the calculations on the report.
I would first try to do the calculations in a query.

Dale

 

[Summer123]

so how do i do it on a query? i know i can add by building it but here's what the issue is i want to add hours for customer one... so here is an example

tblcommonhrs
name hr1 hr2 hr3
Customer1 20 30 10
Customer1 10 20 10
Customer3 40 20 20

i want to add customer1 hours only so the result is
name hr1 hr2 hr3
Customer1 30 50 20

 

[Summer123]

here is a sample database

 

[Summer123]

any help on this would be great...