Problem with getting the correct sum.

[Guest]

Hi


I have a problem getting a report to act the way I want it to. I hope I can
explain this correct so someone can help.

I have a table with general information such as Ride Name, Period, Week,
Scheduled Hours.

Another table with down times and reasons and so on.

There is a query joining the 2 tables for the report, there can be several
down times for a ride in a specific week, so the query lists multiple rows
with the general info and the down time that works fine for most all the
information I need in the report. The report is grouped by Period, Week, Ride
& Cause with Scheduled Hours being in the Week Header. The problem is I need
to Sum the Scheduled Hours for the Week for all Rides when I do that it sums
all the entries (if there are 4 down times for a specific ride in the week it
adds that rides Scheduled Hours 4 times) I only need the Scheduled Hours once
for each ride so I can get a total of all the Operating hours for that week.

I hope I explained this so it makes sense. I will send the tables, query &
report if that will help,

Thanks in advance for any help with this problem.
Chuck

 

[Marshall Barton]

I have a problem getting a report to act the way I want it to. I hope I can
explain this correct so someone can help.

I have a table with general information such as Ride Name, Period, Week,
Scheduled Hours.

Another table with down times and reasons and so on.

There is a query joining the 2 tables for the report, there can be several
down times for a ride in a specific week, so the query lists multiple rows
with the general info and the down time that works fine for most all the
information I need in the report. The report is grouped by Period, Week, Ride
& Cause with Scheduled Hours being in the Week Header. The problem is I need
to Sum the Scheduled Hours for the Week for all Rides when I do that it sums
all the entries (if there are 4 down times for a specific ride in the week it
adds that rides Scheduled Hours 4 times) I only need the Scheduled Hours once
for each ride so I can get a total of all the Operating hours for that week.

I don't see why you need to sum the scheduled hours. You
already have that value in the week's record, just bind a
text box in the week header to the Scheduled Hous field.