Report on current record

  • Thread starter Thread starter Rick Patterson
  • Start date Start date
R

Rick Patterson

I have a form used to enter daily time sheets for technicians. Each time
sheet has multiple jobs on it for which details must be entered
(i.e.:dispatchtime, arrivetime, leavetime, TasksSold, BillableTime,
DollarsCollected, etc.) To facilitate entry of multiple jobs for each tech
each day I use a sub form (JobDetails) which is referenced to and
superimposed onto the main form (JobSheet). I would like to have a report
on the form that would give a quick total of that day's activity to compare
with the technician's own summary information as a cross check prior to
moving on to the next JobSheet for another Tech or day. (If a problem is
noted I can back up to the record with the error to correct it.) The
problem is that I am having trouble finding a way to limit a query to just
the records associated with the current JobSheet. Is there a way to do this
automatically at the click of a button or am I going to have to enter the
JobSheetID number for each query/Report.

Any hints would be greatly appreciated by this novice who at the moment
feels in over his head.

Thanks
 
If you just want to show a summary of a column in the JobDetails subform,
just put a sum textbox on the subform's footer . Next create a text box on
JobSheet and enter the data source as
"=[JobDetails ]![Form].[NameOfYourSummationTextbox]
..
 
Back
Top