Report - print calculated field off of form to a report

Summer123

Registered User.
Local time
Today, 08:21
Joined
Feb 9, 2011
Messages
216
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?
 
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
 
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
 

Users who are viewing this thread

Back
Top Bottom