Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #17  
Old 04-12-2016, 04:15 PM
JennEx JennEx is offline Unable To Get Proper Merged Results Windows XP Unable To Get Proper Merged Results Office 2013
Competent Performer
Unable To Get Proper Merged Results
 
Join Date: May 2010
Posts: 162
JennEx is on a distinguished road
Default

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.

Quote:
Yes, but you're also getting time outputs in cells that don't have them
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.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
proper snoforlife Excel Programming 0 01-26-2016 02:16 PM
Unable To Get Proper Merged Results Hyperlinks Not Linking to Proper Sections of Doc MoiraB Word 2 08-26-2015 07:13 PM
Unable To Get Proper Merged Results Table will not allow sorting because "cells are merged". I can't find the merged cells. wendyloooo Word Tables 1 05-26-2015 01:19 PM
Proper Text Format sufian,naeem Excel 1 05-05-2014 05:59 AM
2013 search results take a long time - they fill in as results in reverse date order themookman Outlook 0 10-11-2013 12:01 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:59 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft