I simply replaced the attachment in post #12.
Yes, but you're also getting time outputs in cells that don't have them:
.
Possibly, in which case we might need to insert a dummy data row at the top of the worksheet, which we can then use a SKIPIF field to exclude from any outputs.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul, happy to see you back.

So, with your data (the corrected version) and most recent report (from post 2), no changes on my part, this is the result ...



Not much improvement. In fact, the time ranges in section 1 and 2 that used to be ok are off now. LOL I've updated the fields that are displaying incorrect data by highlighting them in red.

I looked at my datasource, in particular the fields seemingly giving me the problems. I discovered that the colummns r#_base and r#_pitching weren't text. Testing the apostrophe possibility, upon removing it in that cell, the resulting value was a time formatted value. I entered "75" and it showed as 0:00.

I changed all the r#_base and r#_pitching columns to text and reran the merge document. Still crazy merged fields for those fields I changed to text. Closed the report, went back to the data and removed all the apostrophes. Reran the merge with the same results.

Among other oddities.

I also reduced the report to just 4 sections in the table instead of 8 just on a whim and experienced the same bad data for those 4.

So, it appears as though I may have things resolved. I won't say I'm overly confident, it seems too good to be true. It has been one of the most challenging, inconsistent and unpredictable challenges I've ever faced in the Microsoft Office World.

No sense in rehashing all the odd problems encountered. I am in know way a pro, so I can only suspect all problems encountered with this report (and perhaps in other problems with other reports), had something to do with the tables that formed the structure of my report.

Applying all my merge fields, rules and formula to a basic document (no tables etc), all fields populated with the data as expected. There was nothing erroneous with the data, the mergefields, rules or formulas.

After rebuilding my report with the tables, and copying and pasting the merge components from the basic document to their respective places in the table, everything seems to be populating as expected.

What confused me, and still confuses me to an extend (I'm just happy it works but it makes me fear that the success may be short lived) is that during all my testing up to today, I was getting different results between my school and home computers. WIth this latest development, my time formatting is being accepted in it's basic, unprocessed form, something that earlier, required complex formula to ensure proper presentation. These appear to no longer be issues.

I may be back!

PS ... Paul, thank you for your message! I was unable to reply back.

Hi Jenn,

I'm glad you've got it sorted.

As for being unable to PM me, that's sadly because I had to turn off the 'reply' functionality due to the frequency with which some new members, in particular, think they can just PM me for answers to their questions instead of using the public forum.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]