JasonPurdueEE
Technical User
Ok guys, I am realy stumped on this one. Heres what I have: In my database I have a one-to-many relationship where one WTL_id can have multiple Impacts. I store the TotalRegHours field in the WTL_id table. When I pull the info onto my report, if I have multiple Impacts, it shows the TotalRegHours each time. This causes my calculation to be off dramatically.
I tried to hide duplicates but this didnt work either (if there were 2 records that were unique but had the same number in the TotalRegHours column, it hid the second one). This wont work. Theres also the problem with hiding duplicates when the report spans to the next page (which mine will most of the time).
I need to have it display (or just sum) the TotalRegHours only once per WTL_id. Does anybody know how to do this? If clarification is needed, please let me know. Thanks.
JASON
I tried to hide duplicates but this didnt work either (if there were 2 records that were unique but had the same number in the TotalRegHours column, it hid the second one). This wont work. Theres also the problem with hiding duplicates when the report spans to the next page (which mine will most of the time).
I need to have it display (or just sum) the TotalRegHours only once per WTL_id. Does anybody know how to do this? If clarification is needed, please let me know. Thanks.
JASON